<<Back to Oracle DataGuard Main Page
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode - while performing switchover
Cause: Oracle reports the error during switchover because it find the mismatch for the value of LogXptMode property between primary and standby databasesSolution: Change the value of property LogXptMode from ASYNC to SYNC for all the databases member of this dataguard configuration
DGMGRL> edit database <DB_NAME> set property LogXptMode='SYNC';
Example
$dgmgrl
DGMGRL> connect sys@APX1TP
Password:
Connected as SYSDBA.
DGMGRL>
DGMGRL> show configuration;
Configuration - apx1t_dg
Protection Mode: MaxAvailability Members:
APX1TP - Primary database
APX1TS - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 12 seconds ago)
DGMGRL> switchover to APX1TS
Performing switchover NOW, please wait...
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
Failed.
Unable to switchover, primary database is still "APX1TP"
DGMGRL> show database APX1TS LogXptMode;
LogXptMode = 'SYNC'
DGMGRL> show database APX1TP LogXptMode;
LogXptMode = 'ASYNC'
DGMGRL>
DGMGRL> edit database APX1TP set property LogXptMode='SYNC';
Property "logxptmode" updated
DGMGRL> show database APX1TP LogXptMode; LogXptMode = 'SYNC'
DGMGRL> switchover to APX1TS
Performing switchover NOW, please wait...
New primary database "APX1TS" is opening...
Oracle Clusterware is restarting database "APX1TP" ...
Switchover succeeded, new primary is "APX1TS"
DGMGRL>
DGMGRL> show configuration;
Configuration - apx1t_dg
Protection Mode: MaxAvailability
Members:
APX1TS - Primary database
APX1TP - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 52 seconds ago)
Comments
Post a Comment