1.Change the dataguard configuration protection mode fails with ora-16627
2.check the standby database logxptmode
3.Change the log transport mode to sync from async
4.Change the protection mode from maxperformance to maxavailability
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:
Hello Param,can you plz call me on +91-8523006226 or maill me krisrichard@gmail.com
Regards
Krishna
Post a Comment