Recovering From an Oracle Data Guard Data Replication Error

Language:

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 the 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.
Note - You can also accomplish this procedure by using the Oracle Solaris Cluster Manager browser interface. Click Partnerships, click the partnership name, click the protection group name, click the data replication component name, and click Edit. For more information about Oracle Solaris Cluster Manager, see Chapter 13, Using the Oracle Solaris Cluster Manager Browser Interface in Oracle Solaris Cluster 4.3 System Administration Guide.

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 Geographic Edition settings, type:
```
phys-paris-1# geopg modify-replication-component \
-p replication_mode=New-protection-mode \
ODG-configuration-name protection-group
```
Revalidate the protection group configuration.
Note - You can also accomplish this procedure by using the Oracle Solaris Cluster Manager browser interface. Click Partnerships, click the partnership name, highlight the protection group name, and click Validate. For more information about Oracle Solaris Cluster Manager, see Chapter 13, Using the Oracle Solaris Cluster Manager Browser Interface in Oracle Solaris Cluster 4.3 System Administration Guide.
```
phys-paris-1# geopg validate protection-group
```
where protection-group specifies the name of the Oracle Data Guard protection group.
Review the status of the protection group configuration.
```
phys-paris-1# geopg list protection-group
```
where protection-group specifies the name of the Oracle Data Guard protection group.