Oracle GoldenGate Concepts and Architecture Made Simple!

GOLDENGATE TUTORIAL

Oracle GoldenGate Concepts and Architecture Made Simple!

Oracle Goldengate supports the replication of data across various heterogeneous platforms. The Goldengate replication topology includes the capture and transfer of the extracted data from the source database, across to the destination database.

Below are the topologies which can be used to fulfill various data transfer requirements using data replication.

Oracle Goldengate

Goldengate Topologies

• Uni-directional: Data is replicated in one direction from source to target

• Bi-Directional: The data flows in both direction and stays synced up between site A and site B

• Peer to Peer: Similar to Bi-directional but involves more that 2 databases which stay synced up

• Broadcast: Data from source is sent to multiple destinations

• Consolidation: Data from multiple sources is delivered to one destination DB

• Cascading: Data from one source is sent to multiple destinations

Oracle Golden Gate Logical Architecture

The Oracle Golden Gate architecture consists of the following components:

Oracle Golden Gate Architecture diagram

Oracle Golden Gate Architecture diagram

GoldenGate Components

Manager: The Manager is the process which starts the other Goldengate processes. This process must be running on the source and target system for the configuration and starting up of all the other Goldengate processes. he Manager process also manages the disk space by purging the old trail files. Only one Manager Process is required for every Goldengate installation.

Extract: The Extract process is responsible for capturing the committed DML transactions and the DDL from Oracle Redo logs. Then Extract writes these data changes into Trail or Extract Files.

Data Pump: The Pump process which is also an extract process is optional in the Goldengate setup. This process copies the Trail files containing the data to the target system.

Replicat: The Replicat process is the apply process in the Goldengate configuration. This process runs at the end point of the data delivery chain on the target database. This process reads the destination trail files and applies the data changes to the target systems.

Trail/Extract Files: The Extract process on the source database creates trail files for consumption by the pump process for transfer to remote database or for consumption by a local replicate on the source database.

Checkpoint: The Extract Pump & Replicat processes use checkpoints for tracking the progress of these processes. This mechanism marks the location up to point where the data changes have been retrieved or applied from the trail files. This is useful when processes need to recover (without any data loss) or need to know the starting point after a failure.

Collector: The Collector process runs on the target system and writes the data changes from the source database in the target Trail Files known as RMTTRAIL. Before copying it to RMTTRAIL it reassembles the files.

Read here more on Goldengate Installation setup.