Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
<<Back to Oracle DataGuard Main Page
How to Change DataGuard Protection Mode using dgmgrl
DGMGRL> show configuration verbose;Configuration - APX1T_dg
Protection Mode: MaxPerformance
Members:
APX1TP - Primary database
APX1TS - Physical standby database
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
Failed.
Note:- Protection mode maximum availability and maximum protection is only supported with LogXptMode=SYNC and therefore before changing the protection mode you must change the LogXptMode to SYNC
DGMGRL> SHOW DATABASE 'APX1TS' 'LogXptMode';
LogXptMode = 'ASYNC'
DGMGRL> edit database 'APX1TS' set property LogXptMode='SYNC';
Property "logxptmode" updated
DGMGRL> SHOW DATABASE 'APX1TS' 'LogXptMode';
LogXptMode = 'SYNC'
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Succeeded.
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 7 seconds ago)
Comments
Post a Comment