Skip to main content

Brief Comparison between the Data Guard and Golden Gate Processes

By March 28, 2022August 28th, 2022No Comments2 min read

I can see the below two solutions are demanding replication tools or features available in Oracle Technology.  Even though the product is different, the technology/terminology is almost the same with minor differences.

Let’s explore what the active or major background processes in Data Guard are.

Data Guard
1. Process A reads data from Log buffer (or) redo logs (or) Archive logs – Source. LNS
2. Process B transfers data from Site HQ to Site DR into Standby redo logs – Network RFS
3. Process C applies data from standby redo logs to Database – MRP – Target MRP

Let’s explore what the active or major background processes in Golden Gate are.

Oracle Golden Gate
1. Process A reads data from redo logs and writes it into Trail files. – Source Extract
2. Process B transfers trail files to DR Site – Network (Source) Pump(data pump)
3. Process C applies data into DR Database – Target Replicat apply


The architecture is almost the same, with little difference in terminology and functionality. I hope this comparison helps readers to understand the brief difference between these two technologies.

Below are the few key prerequisites for the Golden Gate and Very High-Level steps.

  • Every table should have Either a Primary key (or) Unique Index Key
  • Archive log mode
  • Force Logging
  • Supplemental Log data Enable
  • Create GG Admin user
  • enable_goldengate_replication to TRUE
  • Sequences should be odd in one site and even in another site (or) vice versa
  • add trandata for each table/columns
  • export / import
  • create extract
  • create pump
  • create replicat in the target

Leave a Reply