O'Reilly logo

Oracle GoldenGate 12c Implementer's Guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Bidirectional configuration options

When implementing a bidirectional configuration, you must consider the following areas to avoid data integrity issues. These are as follows:

  • Loop detection
  • Conflict detection
  • Conflict resolution
  • Replicating Oracle sequences
  • Oracle triggers

Let's take a look at the first potential problem (data looping) and how to detect it.

The loop detection

GoldenGate has a built-in loop detection, which is configured through the IGNOREREPLICATES and GETAPPLOPS parameters to prevent local transactions from being replicated and causing endless loops. Another solution would be the TRANLOGOPTIONS EXCLUDEUSER parameter in the Extract process configuration, which effectively blocks the GGADMIN user on the target system (the user associated ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required