Wednesday, November 19, 2025

Tip of the Day - Oracle & PostgreSQL (Mon, Feb 02 2026)

Source-side Components for Oracle Goldengate 19c (Classic Architecture)


The source system is responsible for capturing committed database changes and preparing them for delivery to the target system.

Following are the components of the Source-side components for Oracle Goldengate 19c (Classic Architecture).
  1. Source database
  2. Manager Process (Source Side) - Control processes on the Source system.
  3. Extract Process - Change capture process on the source system.
  4. Data Pump (Secondary Extract) Process - Optional secondary extract process.
  5. Local Trail Files - Temporary staging files to store changes sequentially.
  6. Checkpoints (Source side) - Tracks the current processing position of Extract and Data Pump process.
  7. Parameter files (Source Side) - Define the behavior and configuration of source-side processes.
  8. Report Flies (Source side) - For diagnostic and troubleshooting error and slowness.