Oracle Database

Oracle GoldenGate

Enterprise Change Data Capture and data replication for Oracle Database - covering architecture, licensing, and how GoldenGate compares to open-source alternatives.

What is Oracle GoldenGate?

Oracle GoldenGate is Oracle's enterprise CDC and data replication product. It reads transaction logs from source databases and streams change records to targets in near real time - other Oracle databases, Kafka, PostgreSQL, flat files, and more. It's been in production at large scale for decades and shows up most often in financial services and telecoms where the Oracle support contract already covers the license cost.

GoldenGate supports heterogeneous replication - from Oracle to Oracle, Oracle to PostgreSQL, Oracle to Kafka, Oracle to flat files, and many other combinations. That flexibility is what makes it a common choice for zero-downtime migrations, active-active multi-master configurations, and feeding data warehouses from operational Oracle systems.

GoldenGate 23ai consolidated the product line under one architecture. You can run it on-premises as always, or use OCI GoldenGate - the fully managed Oracle Cloud version that removes the infrastructure overhead. For Kafka targets, GoldenGate 23ai includes a Kafka handler with Avro and JSON output and Confluent Schema Registry integration.

GoldenGate Architecture

A GoldenGate pipeline has three main process groups. The Extract process runs near the source database, reads the redo logs, and writes committed DML and DDL changes into GoldenGate's trail files. The Data Pump is an optional secondary Extract that reads trail files and forwards them across the network to the target side. The Replicat process reads trail files at the target and applies changes to the destination - a database, a Kafka topic, or another supported system.

Trail files act as a durable buffer between Extract and Replicat, so both processes can run at their own pace and recover independently. The Manager process keeps everything running, and in 23ai deployments the Admin Client provides a REST API for configuration and management.

GoldenGate vs Debezium

Dimension Oracle GoldenGate Debezium
License Commercial (Oracle) Apache 2.0 (open-source)
Cost High (per-processor) Free
Oracle support Native - deep Oracle integration LogMiner or XStream (requires GG license)
Heterogeneous targets Many (Oracle, PG, Kafka, files…) Kafka, HTTP, Kinesis, Pub/Sub…
Latency Sub-second Seconds (LogMiner), sub-second (XStream)
Operational model Oracle support + DBA expertise Community, Red Hat subscription optional

If you already have a GoldenGate license through your Oracle support contract, it's often the natural choice - especially for Oracle-to-Oracle replication or zero-downtime migrations. If you're building a new event-driven pipeline targeting Kafka and don't want to pay for a GoldenGate license, Debezium on LogMiner is the typical starting point.

Guides & Research

In-depth GoldenGate guides are in progress. Topics are drawn from production architecture and migration research.

GoldenGate 23ai Microservices Architecture - coming soon

REST API management, microservices deployment model, and migration from classic GoldenGate to 23ai.

GoldenGate CDC for Oracle Exadata - coming soon

Architecture patterns and performance considerations for GoldenGate Extract on Exadata, including Smart Scan interactions and log management.

GoldenGate Licensing and Pricing Guide

Model license costs by processor count and target type, explore K8s node scoping rules, and build a per-tenant pricing strategy for managed CDC services.

GoldenGate vs. Debezium: Oracle CDC Comparison

Architecture, cost, and consistency trade-offs for Oracle CDC, with an interactive recommendation engine for choosing between the two.

Oracle CDC: EBR and Online DDL Compatibility

Compare GoldenGate, XStream, and Debezium on Edition-Based Redefinition cutover handling, supplemental logging, and online DDL locking. Covers Oracle 19c and 23ai configuration.

Frequently Asked Questions