PROTECTION_LEVEL being RESYNCHRONIZATION in a DATA GUARD environment
Last updated on APRIL 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2013***
The primary database runs in MAXIMUM AVAILABILITY protection mode. After loosing connectivity to the physical standby database, the protection level goes to RESYNCHRONIZATION, and remains at RESYNCHRONIZATION even after the connectivity to the standby is reestablished. You wonder when the protection level will go back to MAXIMUM AVAILABILITY.
If you are using the Data Guard Broker and Fast-Start Failover, Fast-Start Failover will not be initiated as long as the Protection Level stays in 'RESYNCHRONIZATION'. The Data Guard Broker will report this Error:
The network connection between the primary and the physical standby database is disconnected for some reason.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms