GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Golden Gate Extract - Switchover Database

We have an integrated extract (golden gate 19.1) running on Oracle 12c primary database.

The primary database will be switched over to a standby database (Data Guard).

Then, after 1 hour or so we will switch back to the primary database.

The plan is to stop the extract just before the primary switchover and start the extract after switching back to the primary. 

For the period that the standby is in read-write mode, I presume archive logs will be shipped to the primary (read-only).

Once the standy by is switched back to the primary, will the extract still work from the point it stopped before switching the primary database?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center