hadr和tsa 搭建完毕,在测试的时候,个人手贱,使用了reboot主机的方式测试,不知道为什么,备机也重启了。都起来后,hadr两个都成了备机了。而且没有发搞主机,下面是两个hadr的状态,请各位大侠给看下该怎么处理:
怎么样才能让hadr恢复正常状态呢?
db2pd -db trade -hadr
Database Partition 0 -- Database TRADE -- Active Standby -- Up 0 days 00:02:11 -- Date 04/24/2014 15:29:54
HADR Information:
Role State SyncMode HeartBeatsMissed LogGapRunAvg (bytes)
Standby RemoteCatchupPending Nearsync 0 0
ConnectStatus ConnectTime Timeout
Disconnected Thu Apr 24 15:27:44 2014 (1398324464) 240
PeerWindowEnd PeerWindow
Null (0) 300
ReplayOnlyWindowStatus ReplayOnlyWindowStartTime MaintenanceTxCount
Inactive N/A 0
LocalHost LocalService
10.6.10.3 DB2_HADR_2
RemoteHost RemoteService RemoteInstance
10.6.10.13 DB2_HADR_1 db2inst1
PrimaryFile PrimaryPg PrimaryLSN
S0000000.LOG 0 0x000000000FA91ED6
StandByFile StandByPg StandByLSN StandByRcvBufUsed
S0000006.LOG 1 0x000000000FA91ED6 0%
[db2inst1@hzhs010003 ~]$
[db2inst1@hzhs010013 ~]$ db2pd -db trade -hadr
Database Partition 0 -- Database TRADE -- Standby -- Up 0 days 00:13:46 -- Date 04/24/2014 15:36:53
HADR Information:
Role State SyncMode HeartBeatsMissed LogGapRunAvg (bytes)
Standby RemoteCatchupPending Nearsync 0 1
ConnectStatus ConnectTime Timeout
Disconnected Thu Apr 24 15:23:08 2014 (1398324188) 240
PeerWindowEnd PeerWindow
Null (0) 300
LocalHost LocalService
10.6.10.13 DB2_HADR_1
RemoteHost RemoteService RemoteInstance
10.6.10.3 DB2_HADR_2 db2inst1
PrimaryFile PrimaryPg PrimaryLSN
S0000000.LOG 0 0x000000000FA90010
StandByFile StandByPg StandByLSN StandByRcvBufUsed
S0000006.LOG 0 0x000000000FA90010 0%
[db2inst1@hzhs010013 ~]$
收起