本帖最后由 kimm_yong 于 2011-2-15 18:50 编辑
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
切换后的PRIMARY端:
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
|
|