Category Archives: GoldenGate
GoldenGate Common Errors and Solutions
Multi-tenant Environment GoldenGate
Snapshot too old GoldenGate
v$transaction
Identify any in-flight transactions prior to starting extract and export for GoldenGate
GoldenGate Auto Conflict Detection and Resolution for Active-Active
GoldenGate 11.2.0.3 to 19.1.0.0.4 via GoldenGate HUB
Setup includes
VM Hub setup can be used
Either VirtualBox and/or VMWare can be used
Setup the hub according to MRC standards with software installs as well as client installs
Links to scripts and other posts will be here soon……
Ensure the timezone is correct between the servers otherwise the testing will not complete
Ensure the supplemental logging is complete
The setup includes 12.3.0.1 GoldenGate (and patches) installed on the hub server to talk to the 11g (11.2.0.3.0) database
it also includes 19c GG setup to talk to the 19c database
Extracts are setup in the 12c GG home to talk to 11g and share a common trail file location
Make sure the mrcenv file being used allows for setup of the environment for both 12c GG and 19c GG
mrchost_mrcenv can be used for both environments
Once completed with this setup make a snap like I did in order to make the config easy to propagate
GoldenGate Veridata
Feb 5th 2020
GoldenGate Number Of Replication Groups
We are currently looking into the recommendation of having a single extract / replicat replication group.
I may change my opinion on recommending the number of extracts / replicats for a particular customer, I have based this on some information in discussions some really knowledgeable folks. I am going to consider using this as a guideline from now on to create a single extract details to follow…..