oracle_12_goldengate_basic

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 [2020/10/26 19:11] – [Full migration] 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_destination| Configure the Replicat]]
- +
-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_p2| Restore the Base]] +
-  - [[oracle_12_goldengate_conf_prepare_destination| Configure the Destination]]+
   - [[oracle_12_clean_environment|Clean the environment]]   - [[oracle_12_clean_environment|Clean the environment]]
  
 +====Zero-Downtime Setup====
 +  - [[oracle_12_goldengate_zero_downtime_config|Configuration]]
  
 ====Schema Migration==== ====Schema Migration====
  • oracle_12_goldengate_basic.1603739473.txt.gz
  • Last modified: 2020/10/26 19:11
  • by andonovj