Thanks for the question, Tyler.
Asked: February 21, 2024 - 2:45 am UTC
Last updated: March 18, 2024 - 3:27 am UTC
Version: 19.20
Viewed 100+ times
You Asked
Howdy,
The current set up I'm looking at is an OLTP production system running Oracle 19.20 (4 instance RAC) with active data guard. This system is seeding a data warehouse running Oracle 19.20 by way of Oracle GoldenGate via an integrated extract. At present the warehouse does not have a DR solution in place and that's the point of the post.
I'm wondering what the best solution would be for a warehouse DR strategy when GoldenGate is in play like this. I assume data guard again but happy to hear other thoughts. The bulk of the questions I have involve the GoldenGate component. I'm not sure how that would need to be set up / configured in order to minimize the complexity in any role transitions from either the transactional or warehouse (or both); and what scenarios can be handled seamlessly and which would require manual intervention.
Thanks a bunch!
Cheers,
and Connor said...
There is a relatively recent tech paper on dealing with GG in a DataGuard/HA environment which walks through the setup of DataGuard with GG in mind.
https://www.oracle.com/a/tech/docs/platinum-maa-ogg-microservices-architecture-with-adg.pdf The main "departure" from a standard DataGuard setup is the use of DBFS to store cluster-wide information
but there are several other configuration options provided as well.
Thanks to GG PM Veeratteshwaran Sridhar for this info.