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.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
标签: 暂无标签
kimm_yong

写了 2 篇文章,拥有财富 198,被 3 人关注

转播转播 分享分享 分享淘帖
回复

使用道具

P3 | 发表于 2011-2-22 11:40:08
用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
回复

使用道具

P6 | 发表于 2011-2-22 13:55:10
Oracle为了安全,设计只能在备库上切换。
这个可以理解,你怎么会纠结在这方面呢?
回复

使用道具

P3 | 发表于 2011-2-23 11:43:25
当时看到11g提示不能连到到备库, 想可能是在配置网络的环节出现了问题

就没有再仔细查
回复

使用道具

您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈