Guenadi N Jilevski's Oracle BLOG


Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication – Download

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication – Download

In the article you will have a look at an example of using the Oracle GoldenGate (OGG) 11gR2 reverse utility to back out changes replicated from the source database to the target database. In certain cases you need to back out the changes on the target database. For example:

  • undo replication changes committed on the target database
  • rollback an erroneous or accidently issued transaction replicated to the target
  • restore the target data to a state before the replication

Although you can use flashback features, in case of a target Oracle database, or simple backup and restore, OGG 11gR2 provides a generic reverse utility that helps you performing the back out. For you to implement a change back out you need to perform the following steps:

  1. Determine the start and end time for the transactions to be backed out
  2. Configure and start online extract to capture the changes from the source database for this period including the before images and use a trail format that does not compress deletes.
  3. Use the reverse utility to process the trail
  4. Configure and start replicat to apply the change records from the reversed trails and undo the changes that were already applied.

Read online from here or download Using OGG 11gr2 reverse utility to undo changes from OGG replication

November 24, 2012 - Posted by | oracle

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: