Search This Blog

Total Pageviews

Tuesday, 5 May 2026

ORA-16629: database reports a different protection level from the protection mode


ORA-16629: database reports a different protection level from the protection mode





DGMGRL> show configuration ; Configuration - DG_CONF Protection Mode: MaxAvailability <<<<<<---- Members: orcl_stdy - Primary database Warning: ORA-16629: database reports a different protection level from the protection mode orcl - Physical standby database Fast-Start Failover: Disabled Configuration Status: WARNING (status updated 55 seconds ago) standby SQL> select protection_mode,protection_level from v$database; PROTECTION_MODE PROTECTION_LEVEL -------------------- -------------------- MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE primary [-PRIMARY-]sys@orcl_stdy> select protection_mode,protection_level from v$database; PROTECTION_MODE PROTECTION_LEVEL -------------------- -------------------- MAXIMUM AVAILABILITY RESYNCHRONIZATION <<<<< DGMGRL> edit configuration set protection mode as MAXPERFORMANCE; Succeeded. DGMGRL> show configuration ; Configuration - DG_CONF Protection Mode: MaxPerformance Members: orcl_stdy - Primary database Warning: ORA-16629: database reports a different protection level from the protection mode orcl - Physical standby database Fast-Start Failover: Disabled Configuration Status: WARNING (status updated 59 seconds ago) after some time .. DGMGRL> show configuration ; Configuration - DG_CONF Protection Mode: MaxPerformance Members: orcl_stdy - Primary database orcl - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 58 seconds ago) DGMGRL>











No comments:

Oracle DBA

anuj blog Archive