Blog

Retrieving GoldenGate logs, reports, and diagnostics with the REST API
I often need to retrieve report files or logs from GoldenGate deployments, and I wanted to find ways of automating this. Hence this blog, about retrieving all available logs with GoldenGate REST API.

Anatomy of an Enterprise Manager metric extension
Recently, I was working on deploying Metric Extensions automatically in Enterprise Manager, but the more I looked into it, the more it turned into a different question: what does a Metric Extension…

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.

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 AI Service bug confirmed in the Maximum Input Characters setting
In a previous blog, I noted that there might be a bug with the
Maximum Input Characterssetting in GoldenGate 26ai AI Service. The bug was confirmed by Oracle, so let's see what it is exactly.
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.

Deleting GoldenGate trail files via the REST API (
OGG-30375)When automating your GoldenGate deployments, or tearing down a test environment, handling trail files is important.