#extract
9 posts

How to detect a suspended GoldenGate extract
While testing
EVENTACTIONS (SUSPEND)on an extract, I noticed that nothing inINFOtells you the process is suspended.
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.

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.

Rename a GoldenGate Extract with the REST API
In a previous blog, I went through the full procedure of renaming a GoldenGate extract from the
adminclient. I included all necessary steps to avoid missing transactions.
Rename a GoldenGate extract without missing transactions
Throughout my consulting missions, I have often been asked to rename GoldenGate extracts. While this is not a difficult task, it should still be done correctly to avoid missing transactions.

GoldenGate extract abending on NFS trail:
OGG-02897/OGG-01668Input/Output ErrorWhile working on a client's GoldenGate 26ai environment, I ran into a NFS-related replication issue that could have been serious, had it happened in production.

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…

Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai
Classic Extracts have been deprecated in GoldenGate 19c and shouldn't be part of your GoldenGate replications for a long time now.