Oracle^® Solaris Cluster Geographic Edition Data Replication Guide for Oracle GoldenGate

How to Recover After a Replication Error

When an error occurs at the replication level, the error is reflected in the status of the replication status resource of the relevant remote replication component. This corresponding changed status appears in the data replication status field in the relevant protection group's section in the output of the geoadm status command.

1. From one node of either cluster, stop the protection group globally.

   # geopg stop -e global protection-group

2. Fix the root cause of the error in Oracle GoldenGate.

   You might need to take a backup of the primary cluster and apply it to the secondary cluster.

   1. Delete the Oracle GoldenGate groups.
   2. Delete the remaining trail files.
   3. Redeploy the Oracle GoldenGate groups on both the clusters.
3. Start the protection group globally.

   # geopg start -e global protection-group

4. (Optional) To ensure that the secondary cluster is able to master the protection group after the changes, perform a switchover and a switch back.

   # geopg switchover -f -m cluster-newyork protection-group
   # geopg status protection-group
   # geopg switchover -f -m cluster-paris protection-group
   # geopg status protection-group