How to Perform a Failback-Takeover on a System That Uses Oracle GoldenGate
Replication
Use this procedure to restart an application on the original primary cluster
and use the current data on the original primary cluster. Any updates that
occurred on the secondary cluster while it was acting as primary are
discarded.
Note -
This procedure asumes that the original primary cluster was down at the
time of the takeover from the original secondary and that the original
secondary cluster remains down.
-
Check the status of the original primary cluster on a node of the current
primary cluster to ensure that it is down.
# geoadm status
-
Before you boot the original primary cluster, stop the protection group on
the current primary cluster.
# geopg stop -e local protection-group
-
Disable the database and the Oracle GoldenGate resource on the current primary
cluster.
# clresource disable GoldenGate-resource
# clresource disable Database-resource
-
Boot the original primary cluster.
-
Disable the database and the Oracle GoldenGate resource on the original primary
cluster.
# clresource disable Goldengate-resource
# clresource disable Database-resource
-
Take an offline backup of the original primary and redeploy it on the
current primary cluster.
-
Enable the database and the Oracle GoldenGate resource on both the clusters.
# clresource enable Goldengate-resource
# clresource enable Database-resource
-
Re-deploy the Oracle GoldenGate configuration.
-
Delete the Oracle GoldenGate groups.
-
Delete the remaining trail files.
-
Redeploy the Oracle GoldenGate groups on both the clusters.
Make sure that all relevant groups are up and running after you start
them.
-
Re-synchronize the protection group.
Run the following command from the original primary cluster.
# geopg update protection-group
-
From one node in each cluster, validate the configuration locally for each
protection group.
Note -
Ensure that the protection group is not in an Error
state. You cannot start a protection group when it is in an
Error state.
# geopg validate protection-group
For more information, see How to Validate an Oracle Data Guard
Protection Group in Oracle
Solaris Cluster Geographic Edition Data Replication Guide for Oracle
Data Guard .
-
Check the status of the configuration on one node.
# geoadm status
-
Start the protection group globally.
# geopg start -e global protection-group
-
(Optional) Perform a switchover.
# geopg switchover -e global protection-group