My Oracle Support Banner

Controlled DR Tests Using Dataguard with Goldengate in the Mix (Doc ID 1672938.1)

Last updated on MAY 11, 2022

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


We have couple of applications where we have Goldengate configured for one-way replication. The Source and Target DB's have their own separate DR Standby Databases configured using DG. We have been doing controlled DR tests, yearly basis to validate the DB and Application components. Now with Goldengate, we want to see what options available and what would be the steps involved.

Assuming that GoldgenGate Target DB (having Primary and Standby Database configured under Dataguard for High Performance) is going for DR tests, will the following steps help..

- Stop the Goldengate Pump on Source gracefully. Stop Goldgengate all components on Target DB
- Switchover the Databases.
- On Source, update the Pump Parameter file to point to new Standby Server.
- Since all the s/w is pre installed and Replicat Parameter files are copied on Standby Server, Start Goldengate Components.
- Start the Pump Pump.

Are the above steps enough?! Do we need to include anything else? Pls advise.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.