oracle 11g fsfo fast_start failover 问题
本帖最后由 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.14Tuesday, 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.85Tuesday, 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.81Tuesday, 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
用10g做了遍,提示只能在备库执行切换命令,只是提示不同,10g的提示比较直接.
10g提示
DGMGRL> failover to KIMSTD
Performing failover NOW, please wait...
Error: ORA-16600: failover operation can only be submitted at target database
11g的提示:
DGMGRL> failover to test_p
Performing failover NOW, please wait...
Error: ORA-16600: not connected to target standby database for failover Oracle为了安全，设计只能在备库上切换。
这个可以理解，你怎么会纠结在这方面呢？ 当时看到11g提示不能连到到备库, 想可能是在配置网络的环节出现了问题
就没有再仔细查
页:
[1]