_____________________________________________________________________________________________________________________
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)
_____________________________________________________________________________________________________________________
0 comments:
Post a comment