dgmgrl> edit configuration set protection mode as maxperformance;
dgmgrl> show configuration verbose
dgmgrl> edit database dg02 set property 'logxptmode'='sync';
Change to MaxProtection Mode
Step-1: Set logxptmode=sync for both databases.
DGMGRL> edit database dg01 set property logxptmode=sync;
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
Failed.
DGMGRL> edit database dg02 set property logxptmode=sync;
DGMGRL> edit configuration set protection mode as maxprotection;
Operation requires shutdown of instance "dg01" on database "dg01"
Shutting down instance "dg01"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "dg01" on database "dg01"
Starting instance "dg01"...
ORACLE instance started.
Database mounted.
DGMGRL> show configuration verbose;
Configuration
Name: dgconfig1
Enabled: YES
Protection Mode: MaxProtection
Fast-Start Failover: DISABLED
Databases:
dg01 - Primary database
dg02 - Physical standby database
Current status for "dgconfig1":
SUCCESS
NOTE:
Now just try to change the logxptmode=async, it will through an error because it will voilate MXPROTECTION rules.
EX:
No comments:
Post a Comment