Can GoldenGate synchronize from One source DB to multiple target DBs

Posted on 2014-07-18
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 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    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

    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

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now