Master to Master Replication in Oracle

3283400

Hello All,

I have a doubt here i know the concept of Dataguard and stuff but i want to know whether

we can have master to master replication in Oracle same as of MySQL

is it possible?

Regards,

Joel Mervin S

top.gun

So dual replication in Oracle is the Golden Gate product.

Start here:

https://www.oracle.com/middleware/data-integration/goldengate/

top.gun

So dual replication in Oracle is the Golden Gate product.

Start here:

https://www.oracle.com/middleware/data-integration/goldengate/

top.gun

Here are the white-papers:

https://www.oracle.com/middleware/technologies/goldengate.html

Cobert

As @Top.gun has mentioned, there is Golden Gate, which is a paid for product from Oracle.

dbms_streams (superseded dbms_replication but deprecated) - table, schema or DB
You also have the option of using the older Oracle packages dbms_streams dbms_stream_adm to create replication sets (tables, schemas or the DB), but it can be fiddly and the packages are deprecated. You need to create capture processes too, and it can be troublesome reconciling errors / queue tables, rule sets etc, this is another blog covering basic streams setup, but it is very good and works: We Do Streams: Oracle Streams One Way Table Replication 101

Just make sure to keep an eye on hung apply process!

dbvisit

There's another third party replication product called dbvisit, which can replicate standard edition also.