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:

Prepare the Env (Installation and Setup of the binaries) - Done in the Installation Section

Configure the Extract (So we will have the changes, which happened, during the initial load)

Perform the Initial load

Configuration

Configure Extract

Initial Load

Configure the Replicat

Clean the environment

Schema Migration

A single Schema migration setup

Single Table Migration

Golden gate Configuration & Start