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

Create a base

Restore the Base

Configure the Destination

Clean the environment

Schema Migration

A single Schema migration setup

Single Table Migration

Golden gate Configuration & Start