Differences

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

--- oracle_12_goldengate_basic [2019/10/18 11:04] – external edit 127.0.0.1
+++ oracle_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]]
+  - [[oracle_12_goldengate_conf_prepare_destination| Configure the Replicat]]
+  - [[oracle_12_clean_environment|Clean the environment]]
-P.S. When it comes to conventions, Oracle is a mess :) Since Target in RMAN means the opposite of what it means here.
+====Zero-Downtime Setup====
+  - [[oracle_12_goldengate_zero_downtime_config|Configuration]]
-Based on that let's see our settings:
+====Schema Migration====
+  * [[oracle_12_goldengate_conf_schema | A single Schema migration setup]]
-====Full migration====
-  - [[oracle_12_goldengate_conf_prepare_source| Configure the Source]]
-  - [[oracle_12_goldengate_conf_initial_load| Create a base]]
-  - [[oracle_12_goldengate_conf_initial_load_p2| Restore the Base]]
-  - [[oracle_12_goldengate_conf_prepare_destination| Configure the Destination]]
 ====Single Table Migration====
-  * [[oracle_12_goldengate_conf_singleTable | Export / Import]]
   * [[oracle_12_goldengate_conf_singleTable | Golden gate Configuration & Start]]