Saturday, September 1, 2012

PROTECTION MODE


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