GoldenGate Loop Avoidance GG 12.2

Avoiding rows being added to a target system With Integrated Extract, you should use the TRANLOGOPTIONS EXCLUDETAG <tag> option in order to avoid Looping. This parameter corresponds to the DBOPTIONS SETTAG <tag>. This allows you to configure specific replicats with different tags and either allow or disallow replication of these transactions. Syntax example and Reference […]

Oracle 12.2 GoldenGate New Features Deep Dive

GoldenGate 12.2 New Features Deep Dive Oct 2015

GoldenGate Integrated Capture Mode

The Integrated Capture GoldenGate Mode also known as the Integrated Extract Goldengate process in 12c (also backported to 11gr2) is one of the more interesting and useful feature released with this version. This capture process is the component responsible for extracting the DML transactional data and DDL’s from the source database redo log files. This […]

GoldenGate Setup of a Hub

Setup Of GG Hub Article If the GG Hub server is a standalone environment then the first step is to install the most recent Oracle client on the GoldenGate hub server, choosing the administrator installation. In a hub configuration, GoldenGate is installed only on the hub server, it is not installed on the database servers. […]

GoldenGate sample environment file ggsora12_env

Here is a sample GoldenGate environment file, feel free to comment about changes or additions [code language=”sql”] # This should be a .ggora12_env file # This variable could be used to identify a site export GG_SITE=01 # This could be used to identify a location export GG_LOC=CO # if there is only one DB related […]

GoldenGate 12.2 Performance Tuning Article Heartbeat Table

The heartbeat function in 12.2 is more automated than in previous versions. Heartbeat Table Issue 12.2 Resolved