DGMGRL Edit Configuration and Switch Over fails with Error: ORA-16627

_____________________________________________________________________________________________________________________

Error Description:

DGMGRL edit configuration to Max Availability and switch over command fails with following error message.

DGMGRL> edit configuration set protection mode as Maxavailability;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode


Failed.

DGMGRL> switchover to 'CDSLSTBY';
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 "CDSLPROD"

Solution Description 

Check the redo transmission mode whether it is in Sync or not. If it is async mode you cannot change the configuration to max availability. You can use following commands to switch to sync mode.

advertisements

 

DGMGRL> show database 'CDSLSTBY' 'LogXptMode';
  LogXptMode = 'ASYNC'

DGMGRL> edit database 'CDSLSTBY'
> set property 'LogXptMode'='sync';
Property "LogXptMode" updated

DGMGRL> edit configuration set protection mode as maxavailability;
Succeeded.
DGMGRL>  show configuration;

Configuration - DG_Conf

  Protection Mode: MaxAvailability
  Members:
  CDSLPROD     - Primary database
    CDSLSTBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 260 seconds ago)

_____________________________________________________________________________________________________________________

Website Stats