Recovering From an Oracle Data Guard Data Replication Error

When an error occurs at the data replication level, the error is reflected in the status of the resource in the replication resource group of the relevant the Oracle Data Guard Broker configuration.

For example, suppose that Oracle Data Guard Broker configuration sales-pg, which contains the replicated database sales, is changed from protection mode MaxAvailability to MaxPerformance. The state changes for FAULTED are reflected in the following resource status:

Resource Status = "FAULTED"
Resource status message = "FAULTED - Protection mode "MaxAvailability" given 
for local database sales does not match configured value "MaxPerformance""

Note –

The Resource State remains Online because the probe is still running correctly.

Because the resource status has changed, the protection group status also changes. In this case, the local Data Replication state, the Protection Group state on the local cluster, and the overall Protection Group state all become Error.

To recover from an error state, perform the following procedure.

How to Recover From a Data Replication Error

Use the procedures in the Oracle Data Guard documentation to determine the causes of the FAULTED state.

Recover from the faulted state by following the Oracle Data Guard procedures.

If the recovery procedures change the state of the Oracle Data Guard Broker configuration, this state is automatically detected by the resource and is reported as a new protection group state. If the replication mode does not match the Sun Cluster Geographic Edition settings, type:
phys-paris-1# geopg modify-replication-component -p replication_mode=New-protection-mode \ ODGConfigurationName protectiongroupname

Revalidate the protection group configuration.
phys-paris-1# geopg validate protectiongroupname
where protectiongroupname specifies the name of the Oracle Data Guard protection group.

Review the status of the protection group configuration.
phys-paris-1# geopg list protectiongroupname
where protectiongroupname specifies the name of the Oracle Data Guard protection group.