Overview

In order to perform a switchover, we have to stop every process on the primary, then stop everything on the standby. Once this is done, we have to start extract and data pump on the standby(new primary) and replicat on primary(new standby) So in nutshell our procedure is:

Stop all on Primary

Stop all on Standby

Start Extract + Data pump on Standby (New Primary)

Start Replicat on primary (New standby)

Test the Switchover

Cleanup old Extract on Primary and Replicat on Standby

Process

So let's get's this party on :). Firstly let's define what is what:

Matar - Primary

Naos - Standby

Stop all on Primary

Stop all on Standby

Start Extract + Data pump on Standby (New Primary)

Start Replicat on primary (New standby)

Test the Replication

We can insert a row into empty table on the standby(new primary)

Check it on the primary(New standby)

Count the rows of all tables within one schema

Sequences

Since golden gate doesn't deal with sequences, (we can configure, but it will be nuts :) ) We can simply re-create the sequences as follows:

!!!Happy End!!!