Oracle Goldengate Tutorial - Beginner (Level 1)

Oracle Goldengate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise.Its modular architecture gives you the flexibility to extract and replicat selected data records, transactional changes and changes to DDL.

In simple terms, Oracle GoldenGate is a Transaction level data replication software from Oracle Corporation. It can replicate data in one-way (Uni-directional) and two ways (Bi-directional) between homogeneous and heterogeneous databases (Such as, Oracle-Oracle, Oracle-SQL Server etc.). It maintains data integrity by applying the DML (and DDL) changes on the target database, in the same order, that on the source database.

With this flexibility, and the filtering, data transformation, and custom processing features of Oracle Goldengate, you can support numerous business requirement.

• Business Continuance and high availability
• Initial Load and Database Migration
• Data Integration
• Decision support and data warehousing

Oracle Goldengate Supported Topologies

Overview of the Oracle Goldengate Architecture

Oracle Goldengate is composed of the following components

• Extract
• Extract process is the extraction or capture mechanism of Oracle GoldenGate, which runs on the Source system.
• You can configure Extract in one of the following ways
• Initial Load
• Change Synchronization
• If data pump process is configured, Extract process writes the change record in to physical files on dis, called trail.

• Data Pump
• Data Pump is a Secondary Extract Group within the Source Oracle Goldengate configuration.
• The data pump reads the trail and sends the data operations over the network to a remote trail on the target.
• Trails or Extract Files
• Oracle Goldengate stores records of the captured changes temporarily on disk in a series of files called a trail.
• Replicat
• The replicat process runs on the target system.
• The replicat reads the trail on the target system(Which is sent by either Extract or Data Pump Process), and then reconstruct the DML or DDL operations and applies them to the target database.
• You can configure Replicat in one of the following ways:
• Initial Load
• Change Synchronization
• Checkpoints
• Checkpoints stores the current read and write positions of a process to disk, for recovery purposes.
• Manager
• Manager is the control process of Oracle Goldegate.
• One Manager process can control many Extract or Replicat process.
• Collector
• Collector is the process that runs in the background on the target system when continuous, online change synchronization is active. 
• Collector is started automatically and runs in the background.