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