Oracle Golden Gate – Replicat Process

Replicat Process

Replicat process run on the destination or target server which reads the trail file, get the DML or DDL, and applies them to target database. It acts as a SQL apply. In Oracle GoldenGate, the Replicat process is a key component responsible for applying the data changes captured from the source database to the target database.

Steps in the Replicat Process

1. Reads Trail Files:
   • Replicat reads the local trail files (usually ending in .tr) that contain the captured and formatted data changes.
2. Data Mapping and Transformation:
   • If configured, Replicat can transform or map data from source to target (e.g., renaming columns, changing data types).
3. Applies Changes to Target:
   • Applies the changes to the target database using SQL or native APIs.
   • Supports transactional consistency, meaning it can group changes into transactions and commit them as a unit.
4. Checkpointing:
   • Replicat maintains checkpoints to track its progress. This ensures that if the process stops or fails, it can resume from the last known good point.

Note: During initial load, we can also used regular replicat process to apply changes or we can use initial replicat process to apply