9 Replies Latest reply: Mar 17, 2012 3:00 AM by Zaeem Abbas RSS

    Multimaster Replication

    Zaeem Abbas
      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
          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
            Thanks for your helpful reply. Can you please direct me to documentation to implement Replication using Oracle Streams.
            • 3. Re: Multimaster Replication
              Satishbabu Gunukula
              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
                Thanks a lot. I am reading documentation and will post back if there is any confusion in that.
                • 5. Re: Multimaster Replication
                  Zaeem Abbas
                  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
                    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
                      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
                        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
                          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