GoldenGate and Replication

59.1 Oracle GoldenGate

Real-time, log-based change data capture and replication for heterogeneous sources and targets (Oracle, SQL Server, MySQL, PostgreSQL, Kafka, big data, cloud).

Extract (capture from redo; integrated extract) Trail files

Distribution / Receiver services (formerly Data Pump/Collector)

Replicat (apply; integrated, parallel, coordinated) Microservices Architecture (MA) with Admin, Distribution, Receiver, Performance Metrics services, vs the classic architecture with GGSCI Zero-downtime migrations and upgrades

Active-active replication with conflict detection and resolution (CDR)

Real-time data warehousing and streaming OCI GoldenGate (managed), GoldenGate Free, GoldenGate Stream Analytics.

Database prerequisites: ENABLE_GOLDENGATE_REPLICATION=TRUE, supplemental logging, FORCE LOGGING, and a GG admin user.

59.2 Other Replication and Integration Options

Materialized view replication (legacy), Oracle Streams (desupported), XStream, LogMiner-based tools.

Oracle Sharding / Globally Distributed Database: horizontal partitioning across independent databases with a shard catalog and directors. Raft replication in 23ai.

Global Data Services (GDS).