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
