Skip to Main Content
  • Questions

  • can use both goldengate and activedataguard/dataguard replicate data from the same source DB to different targets?

Breadcrumb

Question and Answer

Bobby Curtis

Thanks for the question, Sylvia.

Asked: February 03, 2018 - 4:05 pm UTC

Last updated: February 05, 2018 - 5:26 am UTC

Version: oracle 12 C

Viewed 1000+ times

You Asked

We have one source DB and plan to use goldengate to replicate the data to the 1st target DB; there is a need to replicate the data to a 2nd target DB and we don't need write access on this target (maybe even don't need read access either), can we use dataguard or activedataguard for replicating the data to the 2nd target while using goldengate to the 1st?

and we said...

Oracle GoldenGate and Oracle DataGuard are used for two different purposes. Oracle GoldenGate is used to perform logical replication of the data contained in a database. Oracle DataGuard is used to provide physical recovery of the source database.

In the example you asked about, you can use both technologies from a single source database. You can also use them together with DBFS to provide a level of high availability for your replication environment.

This link can be used to find more details on the comparison of the two technologies and how they can be used together. http://www.oracle.com/technetwork/database/features/availability/dataguardgoldengate-096557.html



Is this answer out of date? If it is, please let us know via a Comment
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 channel and Chris's channel 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