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.

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)

_____________________________________________________________________________________________________________________