Bidirectional Replication
Capabilities:
- Available for both homogeneous and heterogeneous configurations.
- Distributed processing.
- Both sides are live.
- Oracle GoldenGate‟s low latency reduces the risk of conflicts.
- Oracle GoldenGate provides loop detection
- GoldenGate related tables are created in database which grow in size and require regular cleanup.
Issue:
We installed GoldenGate software with Oracle 11.2.0.4 database and also configured all the bidirectional parameters with no issues but faced an issue while performing the bidirectional replication.
Analysis:
GETAPPLOPS
IGNOREREPLICATES
Note: GETAPPLOPS or IGNOREAPPLOPS parameter to capture or ignore DML operations produced by any application except the local Replicat. By default, application data is captured.
Note: GETREPLICATES and IGNOREREPLICATES parameters control whether DML transactions issued by Replicat are captured or ignored by the Extract process which is processing the same tables on the same system.
c) Start both extracts
d) Then check stats.
3. Check this at database
sho parameter *._transaction_auditing
Cause:
This seems to be a bug on 11.2.0.4
Patch 17571039: INTEGRATED REPLICAT INCORRECTLY APPLY THE CHANGES UNDER LOGIN USER SYS
Solution:
1. Apply the patch 17571039 and then we restarted the process and did some DML operations from site B to site A. We We did not change the old settings in extbi and repint processes at all.
Note: Here extbi is bidirectional extract process name and repint is replicat process name.
Related/Further Reading:
- OGG Extract is not skipping transactions from specific users, “TRANLOGOPTIONS EXCLUDEUSER <db username>”. (Doc ID 1361175.1)
- Oracle GoldenGate: How to replicate compressed table in database
- Oracle GoldenGate: Replicat running but not applying transactions
- Oracle GoldenGate 12c: Step by step Activity Guides
- Oracle GoldenGate 19c Administration
This post is from our Oracle GoldenGate 12c Administration Training, in which we cover Architecture, Installation, Configuring & Preparing the Environment, DML Replication – Online Change Synchronization, Initial Load, Zero Downtime Migration & Upgrading using GoldenGate, Oracle GoldenGate Security, Performance of Oracle GoldenGate and Troubleshooting and much more.
Next Task For You
Get 7+ Courses for DBAs & Apps DBA in a bundle program and learn from the Industry’s best Experts
Leave a Reply