Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oracle_12_goldengate_basic [2019/11/09 11:44] andonovjoracle_12_goldengate_basic [2020/11/06 17:02] (current) andonovj
Line 1: Line 1:
-======Golden Gate Overview======+======Golden Configuration Overview====== 
 +Golden Gate is a separate software of Oracle which enables the configuration of replication between oracle database, but also between Oracle and other databases in heterogenous environment. 
 +In a nutshell, the configuration follows the following steps:
  
-The configuration of GoldenGate replication depends on the architecture which is required:+{{:goldengateoverview.jpg?800|}}
  
-  * Unidirectional +  - Prepare the Env (Installation and Setup of the binaries) - Done in the Installation Section 
-  * Bidirectional +  - Configure the Extract (So we will have the changes, which happened, during the initial load) 
-  * One to Many +  - Perform the Initial load
-  * Round+
  
-Therefore the configuration is different. Let's start with Unidirectional replication as follows: 
  
-  * Source: sourceSVR  <- Source +====Configuration==== 
-  * Destination: destinSVR   <- Target +  - [[oracle_12_goldengate_conf_prepare_source| Configure Extract]] 
- +  - [[oracle_12_goldengate_initial_load|Initial Load]] 
-P.S. When it comes to conventions, Oracle is a mess :) Since Target in RMAN means the opposite of what it means here. +  - [[oracle_12_goldengate_conf_prepare_destinationConfigure the Replicat]] 
- +  - [[oracle_12_clean_environment|Clean the environment]]
-Based on that let's see our settings: +
- +
-====Full migration==== +
-  - [[oracle_12_goldengate_conf_prepare_source| Configure the Source]] +
-  - [[oracle_12_goldengate_conf_initial_loadCreate a base]] +
-  - [[oracle_12_goldengate_conf_initial_load_p2Restore the Base]] +
-  - [[oracle_12_goldengate_conf_prepare_destinationConfigure the Destination]]+
  
 +====Zero-Downtime Setup====
 +  - [[oracle_12_goldengate_zero_downtime_config|Configuration]]
  
 ====Schema Migration==== ====Schema Migration====
-  * [[oracle_12_goldengate_conf_schema | Export / Import]]+  * [[oracle_12_goldengate_conf_schema | A single Schema migration setup]]
  
 ====Single Table Migration==== ====Single Table Migration====
  • oracle_12_goldengate_basic.1573299897.txt.gz
  • Last modified: 2019/11/09 19:44
  • (external edit)