Julien Delattre

Latest posts

• 

  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.

  26 Oct 2026GoldenGate
• 

  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…

  23 Oct 2026Enterprise Manager
• 

  How to detect a suspended GoldenGate extract

  While testing EVENTACTIONS (SUSPEND) on an extract, I noticed that nothing in INFO tells you the process is suspended.

  19 Oct 2026GoldenGate
• 

  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.

  15 Oct 2026GoldenGate
• 

  Removing instantiation filtering from a GoldenGate replicat

  In a recent blog, I explained how instantiation filtering works. DBOPTIONS ENABLE_INSTANTIATION_FILTERING makes a replicat discard any record whose commit CSN is at or below a table's…

  12 Oct 2026GoldenGate
• 

  GoldenGate 26ai AutoSchema TYPEMAP: overriding the default datatype mapping

  In 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…

  08 Oct 2026GoldenGatePostgreSQL
• 

  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 Characters setting in GoldenGate 26ai AI Service. The bug was confirmed by Oracle, so let's see what it is exactly.

  06 Oct 2026GoldenGate
• 

  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.

  05 Oct 2026GoldenGatePostgreSQL
• 

  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.

  01 Oct 2026GoldenGate
• 

  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.

  28 Sept 2026GoldenGateOracle

Projects

Tools

GoldenGate Error Code Explorer

Search the full GoldenGate message set (nearly 6,000 OGG- codes) by code or a pasted log line, and get the severity, cause and action for each, with a link to the blog post where one exists.

GoldenGate REST API Log Reader

A Python script that turns restapi.log (GoldenGate's unstructured, multi-line REST API log) into one JSON object per line, so you can filter it with jq by status, service, HTTP verb, user role, or time window instead of grepping through it by hand.

jq Filter Builder

Visually build jq filters for NDJSON files. Load a file or use sample data, select fields to include/exclude, filter by value, and get the ready-to-run jq command.

MongoDB Log jq Query Builder

Paste MongoDB structured log lines (4.4+ JSON) and click fields to assemble a jq filter live. Presets for slow queries, connection churn, and COLLSCAN detection.