Oracle GoldenGate: DDL Replication To Oracle Targets With Dissimilar Data Structure

Introduction Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are the same. The challenge comes when the source and target tables have a dissimilar table structure; as may exist in a Data Warehouse or Reporting Database. In this […]

How to force OGG to use ENABLED Invalid or Non-Validated Keys

Introduction If a table has a PK constraint or a Unique Constraint that is Non-Validated or Invalid, Oracle GoldenGate will by default not use those keys to uniquely identify a row.  It will use all columns to uniquely identify a row.  This may become an issue due to the increased space required for both trails […]

Oracle GoldenGate: Coordinated Apply

Introduction Oracle GoldenGate (OGG) version 12c introduced the Coordinated Apply. Coordinated Apply provides the ability to spawn multiple OGG Replicat processes from one parameter file. This article discusses configuration options, GGSCI commands, and troubleshooting for Coordinated Apply as of OGG version Main Article OGG 12c introduced the Coordinated Apply; which is a multi-threaded Replicat […]

Database Objects Creation Sequence Could Impact Oracle GoldenGate DDL Replication

Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in this document. Main Article For Oracle GoldenGate (OGG) DDL replication to work correctly, the source and target schemas should be identical. Sometimes even […]