Monday, June 30, 2014

ORA-16627: operation disallowed since no standby databases would remain to support protection mode

1.Change the dataguard configuration protection mode fails with ora-16627
DGMGRL> edit configuration
> set protection mode as
> maxavailability;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

2.check the standby database logxptmode
DGMGRL> show database dbrac2 'LogXptMode';
  LogXptMode = 'ASYNC'

3.Change the log transport mode to sync from async
DGMGRL> edit database dbrac2
> set property 'LogXptMode'='sync';
Property "LogXptMode" updated

4.Change the protection mode from maxperformance to maxavailability
DGMGRL> edit configuration
> set protection mode as maxavailability;
Succeeded.
DGMGRL> show configuration

Configuration - dgmgrl1

  Protection Mode: MaxAvailability
  Databases:
  dbrac1 - Primary database
    dbrac2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS




1 comment:

Unknown said...

Hello Param,can you plz call me on +91-8523006226 or maill me krisrichard@gmail.com

Regards
Krishna