ASE 12.5.3 HA on AIX 严重问题

主服务器yc6501建表说备用服务器yc6502有问题
Msg 911, Level 11, State 2:
Server 'yc6502', Line 1:
Attempt to locate entry in sysdatabases for database 'cpscx' by name failed - no
entry found under that name. Make sure that name is entered properly.

执行
1> sp_companion "yc6502",do_advisory,"all"
2> go
Server 'yc6501' is alive and cluster configured.
Server 'yc6502' is alive and cluster configured.
Msg 926, Level 14, State 1:
Server 'yc6502', Line 1:
Database 'master_companion' cannot be opened. An earlier attempt at recovery
marked it 'suspect'. Check the SQL Server errorlog for information as to the
cause.
Msg 208, Level 16, State 1:
Server 'yc6502', Line 1:
master_companion..sysobjects not found. Specify owner.objectname or use sp_help
to check whether the object exists (sp_help may produce lots of output).
(1 row affected)
(return status = 1)

master_companion应该是代理库吧,重建就行了吗? 或只要改下标志 ?

问题是master_companion所在卷组在yc6502 的确是不能访问的,而只能在yc6501上访问

在主点和备点都执行sp_companion
如果状态都是normal，才能创建表，否则请先解决HA状态之后，再创建表。

如果你看到了xxxx_companion数据库，那状态肯定是有问题的。