switchover 一切正常
DGMGRL> show configuration verbose Configuration - FSF Protection Mode: MaxAvailability Databases: test_p - Primary database test_s - (*) Physical standby database (*) Fast-Start Failover target Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' FastStartFailoverLagLimit = '30' CommunicationTimeout = '180' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL' Fast-Start Failover: ENABLED Threshold: 30 seconds Target: test_s Observer: dbatwo Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Configuration Status: SUCCESS
PRIMARY端
DGMGRL> switchover to test_s Performing switchover NOW, please wait... New primary database "test_s" is opening... Operation requires shutdown of instance "TEST" on database "test_p" Shutting down instance "TEST"... ORACLE instance shut down. Operation requires startup of instance "TEST" on database "test_p" Starting instance "TEST"... ORACLE instance started. Database mounted. Switchover succeeded, new primary is "test_s"
DGMGRL> switchover to test_p Performing switchover NOW, please wait... New primary database "test_p" is opening... Operation requires shutdown of instance "TESTSTD" on database "test_s" Shutting down instance "TESTSTD"... ORACLE instance shut down. Operation requires startup of instance "TESTSTD" on database "test_s" Starting instance "TESTSTD"... ORACLE instance started. Database mounted. Switchover succeeded, new primary is "test_p"
在进行failover 时只能在备库进行切换!!
failover
PRIMARY端
DGMGRL> failover to test_s Performing failover NOW, please wait... Error: ORA-16600: not connected to target standby database for failover Failed. Unable to failover
STANDBY端
DGMGRL> failover to test_s Performing failover NOW, please wait... Failover succeeded, new primary is "test_s"
DGMGRL> failover to test_p Performing failover NOW, please wait... Error: ORA-16600: not connected to target standby database for failover Failed. Unable to failover
上次切换后的STANDBY端(源PRIMARY端)
DGMGRL> failover to test_p Performing failover NOW, please wait... Failover succeeded, new primary is "test_p"
会是哪里的问题呢?
在10g上没遇到这个呢?? 望高手赐教！
注:
我在主库执行shutdown abort 后 ,备库是可以自动切换为主库的
PRIMARY端:
SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL> shutdown abort ORACLE instance shut down.
17:47:37.14 Tuesday, February 15, 2011 Initiating Fast-Start Failover to database "test_s"... Performing failover NOW, please wait... Failover succeeded, new primary is "test_s" 17:47:47.85 Tuesday, February 15, 2011
STANDBY端：
SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL> shutdown abort ORACLE instance shut down.
18:20:18.81 Tuesday, February 15, 2011 Initiating Fast-Start Failover to database "test_p"... Performing failover NOW, please wait... Failover succeeded, new primary is "test_p"
不明白为什么可以实现SHUTDOWN ABORT后自动切换,却不能在PRIMARY端执行FAILOVER TO STANDBY
