Oracle GoldenGate 11g Complete Cookbook

Undoing the applied changes using the reverse utility

Part of the job of setting a GoldenGate replication consists of defining what to replicate. Once these rules are in place, GoldenGate processes scan the redo data for any records for the replicated tables. Most of the time, these changes are intended and generated by some application. However, sometimes some data updates are performed in the source environment by mistake and you would ideally not want them to be replicated to the target environment. In such scenarios, the administrator might want to roll back the changes performed. You can perform such tasks using the latest database technologies, for example, flashback. However, it is very difficult to roll back only a set of transactions ...