Replicat abending with database error 1403

Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very frequently on a production environment when implementing Goldengate for the first time. During the instantiation of the target database, if there is any open transaction which is yet to be committed, the extract is started…

Purge DDL tables in GoldenGate for multiple instances

When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis, Oracle provides a purge process that one can add to the manager parameter file and it will purge as configured. e.g: userid ogg, password xxxx PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30 PURGEMARKERHISTORY MINKEEPDAYS 3,…

Script to add trandata for GoldenGate

Here is a simple script to check which tables are missing trandata and generate the GG (so call DDL) to enable it on them. select ‘add trandata ‘||t.owner||’.’||t.table_name stmt from (select owner, table_name from dba_tables) t, (select owner, table_name from dba_log_groups) s where t.owner = s.owner (+) and t.table_name = s.table_name (+) and s.table_name is…

GGSCI Commands

Commands ggsci> HELP [command] [object] ggsci> help GGSCI Command Summary: Object:          Command: SUBDIRS          CREATE ER                   INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND, START, STATS,…