oracle 11g fsfo fast_start failover 问题

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