This discussion is archived
9 Replies Latest reply: Mar 17, 2012 1:00 AM by Zaeem Abbas RSS

Multimaster Replication

Zaeem Abbas Newbie
Currently Being Moderated
Hello Guys,

I need to setup two nodes multi-master replication setup using Oracle 11g for testing purpose. The DB clients can modify data in any node and changes must be synced in both nodes. Cany anybody please let me know how can I achieve using oracle as I have implemented the same using MySQL 5.5. Any relevant document will be highly appreciated.
  • 1. Re: Multimaster Replication
    Satishbabu Gunukula Oracle ACE
    Currently Being Moderated
    Refer below links in same order, hope it will help,

    http://docs.oracle.com/cd/E19656-01/821-1502/aalfp/index.html
    http://apunhiran.blogspot.com/2009/04/how-to-setup-multi-masteradvanced.html
    http://docs.oracle.com/cd/E14072_01/server.112/e10707/rarmanmaster.htm

    Regards
    http://www.oracleracexpert.com
    Backup and Recovery of OCR
    http://www.oracleracexpert.com/2009/08/backup-and-recovery-of-ocr-oracle.html
    Click here to [Backup and Recovery of Voting Disk
    http://www.oracleracexpert.com/2009/08/voting-disk-backup-and-recovery.html                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
  • 2. Re: Multimaster Replication
    Zaeem Abbas Newbie
    Currently Being Moderated
    Thanks for your helpful reply. Can you please direct me to documentation to implement Replication using Oracle Streams.
  • 3. Re: Multimaster Replication
    Satishbabu Gunukula Oracle ACE
    Currently Being Moderated
    Here you go...

    http://docs.oracle.com/cd/B19306_01/server.102/b14228/config_simple.htm
    http://apunhiran.blogspot.com/2009/07/how-to-setup-up-of-oracle-streams.html

    Hope this helps,

    regards
    http://www.oracleracexpert.com
    transportable-tablespace export and import on Same Endian platforms
    http://www.oracleracexpert.com/2009/08/transportable-tablespace-export-import.html
    Cross platform Transportable tablespace using RMAN
    http://www.oracleracexpert.com/2009/10/cross-platform-transportable-tablespace.html
  • 4. Re: Multimaster Replication
    Zaeem Abbas Newbie
    Currently Being Moderated
    Thanks a lot. I am reading documentation and will post back if there is any confusion in that.
  • 5. Re: Multimaster Replication
    Zaeem Abbas Newbie
    Currently Being Moderated
    Dear Satishbabu,

    I heard that Streams is part of Oracle Enterprise edition. Is there any way we can implement bi-directional and uni-directional replication by using Oracle Standard Edition?
  • 6. Re: Multimaster Replication
    Balazs Papp Expert
    Currently Being Moderated
    I heard that Streams is part of Oracle Enterprise edition.
    wrong
    Is there any way we can implement bi-directional and uni-directional replication by using Oracle Standard Edition?
    yes
    the mighty documentatition covers this as well: http://docs.oracle.com/cd/E11882_01/license.112/e10594/editions.htm#CJACGHEB
  • 7. Re: Multimaster Replication
    Satishbabu Gunukula Oracle ACE
    Currently Being Moderated
    Refer the below link, in same order

    http://www.dba-oracle.com/t_bi_directional_streams_replication.htm
    http://www.orafaq.com/wiki/Oracle_Advanced_Replication
    http://www.databasejournal.com/features/oracle/article.php/10893_3596971_2/Oracle-Bi-Directional-Data-Replication.htm

    hope this helps,

    Regards
    http://www.oracleracexpert.com
    Could Not Get DeploymentManager When Deploying or Undploying Agile
    http://www.oracleracexpert.com/2012/02/could-not-get-deploymentmanager-when.html
    How to Deploy and Un-deploy Oracle Agile Application
    http://www.oracleracexpert.com/2012/02/how-to-deploy-and-un-deploy-oracle.html
  • 8. Re: Multimaster Replication
    Zaeem Abbas Newbie
    Currently Being Moderated
    Dear Balazs,

    Thanks for your quick reply but I can see following.
    wrong
    The documentation at http://docs.oracle.com/cd/E11882_01/license.112/e10594/editions.htm#CJACGHEB clearly mentions that multi - master replication is only part of Enterprise edition only. Check under Integration section.

    Can you please check and confirm. I am sorry if I am bothering you guys much.

    Edited by: 919940 on Mar 17, 2012 1:01 AM
  • 9. Re: Multimaster Replication
    Zaeem Abbas Newbie
    Currently Being Moderated
    Dear Satishbabu Gunukula,

    I am very thankful to you for your continuous support.
    http://www.dba-oracle.com/t_bi_directional_streams_replication.htm
    Clearly mentions that
    Low cost - Multidirectional Streams replication has less configuration costs than RAC and it's free with Oracle Enterprise Edition.
    whereas the documentation at http://docs.oracle.com/cd/E11882_01/license.112/e10594/editions.htm#CJACGHEB says that oracle stream is available in standard edition as well.

    Due to licensing issue I want to setup multi-master replication using Oracle Standard Edition. Frankly speaking so far it seems multi-master replication can't be configured using Oracle Standar Edition. Please make me correct if my understanding is wrong.

    Edited by: 919940 on Mar 17, 2012 12:59 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points