#replicat
8 posts

Import order matters for GoldenGate instantiation filtering
When migrating a large database with GoldenGate, most of the volume is sometimes in old partitions which no longer change.

Removing instantiation filtering from a GoldenGate replicat
In a recent blog, I explained how instantiation filtering works.
DBOPTIONS ENABLE_INSTANTIATION_FILTERINGmakes a replicat discard any record whose commit CSN is at or below a table's…
GoldenGate 26ai AutoSchema
TYPEMAP: overriding the default datatype mappingIn my blog about the new automatic schema evolution feature in GoldenGate 26ai, I was replicating the following table from Oracle to PostgreSQL: The replicat created a PostgreSQL table from an…

GoldenGate 26ai automatic schema evolution: creating missing tables during an initial load
For as long as I have used GoldenGate, an initial load had one prerequisite: the target tables must already exist. Data Pump takes care of it between two Oracle databases.

GoldenGate instantiation CSN explained
For more than ten years (GoldenGate 12.2, released in 2015), GoldenGate has provided a way of performing initial load of tables with a per-table instantiation CSN.

DDL filtering in GoldenGate extract and replicat
When replicating data with GoldenGate, you often want DDL changes (table alterations, new tables, dropped indexes, etc.) to follow alongside DML.

OGG-02454Trail not found in checkpoint file when migrating a Coordinated ReplicatWhen migrating a Coordinated Replicat for a client, I faced a very specific
OGG-02454error that I wanted to share.
Bulk update of GoldenGate extract profiles
After writing blogs about Default profile updates and a bug affecting profiles in GoldenGate 26ai, I realized it would be a good idea to present a quick way to update all processes at once with the…