[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Can GoldenGate synchronize from One source DB to multiple target DBs

Posted on 2014-07-18
Medium Priority
Last Modified: 2014-08-08
Hi, I am using Oralce 10g, 11g standard editions.
I have a requirement to push Transaction Data from DB1(source) to  DB2 and DB3 (targets). Is it possible with Golden Gate?
Alternately, Is Golden Gate capable of syncing data uni-directionally from DB1-->DB2 and then DB2--> DB3.

Pls. educate me on the capabilities of Golden Gate which would support above requirements.
Any pointer in the web would be greatly appreciated.

Thank you
Question by:damarasa
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 750 total points
ID: 40204334
It appears this is possible although I cannot find exact documentation to tell you 'how'.

Check out the following.  It has unidirectional and broadcast setups on the TOPOLOGY slide:

There is an online tutorial that isn't exactly what you are looking for since it is MySQL to Oracle but it shows how to set up unidirectional replication:
Oracle GoldenGate on Linux: Unidirectional Replication from MySQL to Oracle 11gR2
LVL 22

Expert Comment

by:Helena Marková
ID: 40204337
I am not familiar with GoldenGate, so I hope, other experts can answer your question.

Here are links which can help you:
LVL 16

Accepted Solution

Wasim Akram Shaik earned 750 total points
ID: 40206003
In Golden Gate you normally create a replication stream where in  you identify tables to be replicated after this you will create destination dump where in this is configurable.. Ie., one replication stream can be passed on to one or more hosts

This is quite possible

DB1. Replication Destination DB2
DB1 replication destination DB3

Check out this link for more details on this type of configuration


Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question