Overview

Using Datapump is the cleanest way to start or reset golden gate. So let's see how it is:

Golden Gate Set-Up

In that case we want to migrate a single schema and set up one way replication

Server: Source (schema: HR)

Server: Destination

Cleanup

Firstly, we will clean up the schema, by deleting everything

Golden Gate Source Config

On the source we have to configure couple stuff:

Setup Trend Data

Parameters of the Extract

Config Extract

Parameters Dump

Config Dump

Golden Gate Target Config

Once this is working, let's go for the target system:

Replicat Parameters

Config Replicat

On SourceServer

A quick return to the source database, we have to export the schema:

Create a base

We have to create a consistent backup, therefore we have to take current SCN and execute expdp using that scn :)

After you tansfer the file: “exphr.dmp” to the target server, import it :)

On Target Server

Start Replicat

So let's start the Replicat using the scn from the source server and the consistent SCN.