While setting up GoldenGate, we wished there was a way to say “create extract myextract begin scn “, or something similar. However, there is no supported way to get this (of which I am aware at least, but would gladly…
Category: GoldenGate
Programatically creating GoldenGate conflict detection/resolution rules
We initially started with checking all columns in every table for any differences in an active-active environment, and aborting the replicat if it failed. That seems a bit over the top in hindsight, so we changed it to simply discard…
GoldenGate conflict detection in 11.2.1.0 and ignore when multiple statements are in a transaction
In GoldenGate 11.2.1.0, they introduced out of the box CDR (conflict detection and resolution). This is really useful in a bi-directional replication environment such as the one we are building. One question I had about this surrounded what happened if…
ATG primary key data types
Not much today, this is just a place holder as we evaluate conflict resolution schemes for ATG and Golden Gate. Out of the box, it uses an application based sequence generator (DAS_ID_GENERATOR table). You can (and are encouraged to) prepend…
Logdump, the GoldenGate swiss army knife
Logdump is the Swiss army knife of troubleshooting GoldenGate. With it, you can identify things like: * Identify the transaction for a given SCN in Oracle * Identify the transaction at an RBA in the trail file about which the…
Missing GETBEFORECOLS with conflict detection enabled in target table
While we are configuring different environments, we sometimes will change the target to which a datapump points. While using INTEGRATED TRANLOG and the new built-in conflict resolution in GG 11.2.0.1, we found that the new replicat wouldn’t respect the before…
Supplemental logging when running add schematrandata
As I have mentioned in past posts, we are currently implementing GoldenGate with ATG. We want to compare all columns in an update to all columns on the target, as we are implementing bi-directional replication. We found that when we…
Which tables have changes in a GoldenGate trail file?
I use the following to identify which tables have changes recorded in a trail file, as well as how many changes each table has… CMHLDECOMDB01:oracle:cmhecomd1:/u01/app/oracle/acfsmounts/ggate/oracle2/dirdat>strings -a r1000009 | grep ATGDB | sort | uniq -c 6 ATGDB_CORE.DAS_ID_GENERATOR 21873 ATGDB_CORE.DCSPP_ORD_ABANDON 10937…
Using DBMS_LOGMNR with GoldenGate logdump
I honestly don’t know if we will ever use this, but I thought it was useful enough to document. One of the things I struggled with early in our GoldenGate testing was what an RBA was. The term was flipped…
How often does GoldenGate checkpoint?
While running a 10046 trace against a replicat session, I saw UPDATE statements against the checkpoint table. While this isn’t unexpected, as I had configured the replicat to use a checkpoint table, I was curious to see how often it…