Oracle Golden Gate Overview & Components

Introduction to Oracle GoldenGate

Oracle Goldengate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms.

Oracle GoldenGate Architecture allows to replicate selected data, transactional changes, and changes to DDL.

It supports various business requirements like High Availability, Initial Load and Database Migration etc.

Oracle GoldenGate Supported Topologies:

Oracle Golden gate topology

Goldengate Topologie:

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 GoldenGate Architecture:

In Normal terms, Extract process on source captures the transactions happening on source database and writes them to a trail file  . The data pump process ships those trail files to the target host/db server with help of collector. Then the replicate process on target db server, reads those trail files and apply the transactions on target database.

Oracle GoldenGate is composed of the different components as mentioned below:

Extract

Data pump

Replicat

Trails or extract files

Manager

Collector

Leave a Reply

Your email address will not be published. Required fields are marked *