Controlled DR Tests Using Dataguard with Goldengate in the Mix
Last updated on JULY 23, 2017
Applies to:Oracle GoldenGate - Version 220.127.116.11.5 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms