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)
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google