Skip to Main Content
  • Questions

  • Is Oracle Golden Gate a DR solution?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Syed.

Asked: September 07, 2017 - 2:45 pm UTC

Last updated: September 08, 2017 - 3:06 am UTC

Version: 12.2

Viewed 1000+ times

You Asked

Hi gurus,



Had a discussion with Oracle folks and he said that Oracle Golden Gate is a DR solution, where as I don't agree.



And here is what Oracle itself is saying:



Oracle GoldenGate is Oracle’s full-featured replication solution designed to address a wide range of requirements. GoldenGate maintains a synchronized logical copy of a production database that is open read-write at all times. A GoldenGate replica, for example, can offload reporting applications that require read-write database access or can be used to load-balance read-write workloads using multimaster replication. Increased flexibility, however, is accompanied by several trade-offs for data protection and operational simplicity compared to Active Data Guard. GoldenGate is used for disaster recovery by customers who accept these trade-offs in return for its additional flexibility.


http://www.oracle.com/technetwork/database/availability/disaster-recovery-2526839.pdf



Bringing it here, so can see, what others have to say, obviously along with justification.



Looking forward to hearing back.



Best regards

and we said...

Oracle GoldenGate provides data replication for IT environments. Oracle Data Guard provide disaster recovery for IT environments. This is clearly highlighted in the summary of each of the products (provided below). Both products can be used together to provide a highly available solution that covers data replication and disaster recovery as outlined in Oracle's MAA documentation. ( http://www.oracle.com/technetwork/database/availability/ogg-adg-2422372.pdf ).

Oracle GoldenGate:
A comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems

Oracle Data Guard:
Provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database.


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

GG support matrix

Andy, January 14, 2018 - 5:00 pm UTC

Hi Bob,

I wanted to know whether the source and target versions can be different for replication using GG.

Example:
Can I use Oracle Standard Edition 11.2.0.3 at source and 11.2.0.4 at target and use GG (11g or 12c) to replicate data from source and destination?

Is there a matrix available? I was going through the www.oracle.com/technetwork/middleware/data-integration/goldengate12-2-x-cert-matrix-2769360.xls where I can see the supported platforms but not the one which I'm looking at.

Need your help here.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database