3 Replies Latest reply: Mar 11, 2014 4:08 PM by mseberg RSS

    Redundancy

    Merlin128

      I have 3 web/app servers that write to 1 production database.

      For the past several years we have run DataGuard to a standby database, as a live backup because we cannot lose any data..

       

      In a few months we are going to start discussing making this system fully redundant 24/7 zero down time..

       

      We want to load 3 more web/app servers and another production database at another location doing the same thing..

      I am guessing we will use a load balancer appliance in front of the app servers switching the users that connect to one location or the other..

       

      My biggest concern is how do I run two databases and keep the data in sync..

      Should I switch from DataGuard to using Streams, or purchase GoldenGate... what is the best solution for this scenario..

       

      Databases can be upgraded if needed.. They are currently 11.2.0.3 patch 15 with Spatial.. These apps are Map Based and use Google Maps API..

       

      Thanks


        • 1. Re: Redundancy
          mseberg

          Hello;

           

           

          I would use GoldenGate for information consolidation and distribution, or if I needed to work with other systems like DB2 or SQL Server. But not for this. It's more of an ETL tool in my mind.

           

          Since you want zero down time you should know GoldenGate does not support zero data loss, while Data Guard does.

           

          Also GoldenGate uses bidirectional replication and conflicts are likely to occur in a bi-directional environment.

           

          My understanding is that Oracle Streams will not be actively enhanced so I would not use it without a clear understanding of the product direction.

           

          Data Guard is what you want. it has zero data loss capability, corruption detection, automatic database failover, and unlike GoldeGate you only need EE edition or an Active Data Guard license if you need that option.

           

          Data Guard is designed to do exactly what you need. Double check your network requirements and protection mode and carry on. Fast failover exists for problems like yours.

           

          Have you also considered RAC on Data Guard?

           

          Best Regards

           

          mseberg

          • 2. Re: Redundancy
            BPeaslandDBA

            From your requirements, it sounds like you want both databases at both locations to be in sync, and be usable by the application. For the most part, this rules out Data Guard so you will probably want to use Golden Gate. GG can perform two-way replication if needed. That will keep the data in sync.

             

            You could use Active Data Guard to keep the standby in sync and let the application have access to the data, but this access is READ ONLY. As such, it probably rules out Active Data Guard for more applications as most apps will want to write data at least on occasion.

             

            Cheers,
            Brian

            • 3. Re: Redundancy
              mseberg

              Brain;

               

              I'm unable to find a good compare of Data Guard and GoldenGate. I see a few compares between it and Active Data Guard ( which seems fair ) but nothing without Active Data Guard.

               

              This might be getting old but...

               

              http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3349335100346299316

               

              UPDATE

               

              The sheet on the latest version of GoldenGate claims to do all the the things the OP asked for:

               

              http://www.oracle.com/us/products/middleware/data-integration/goldengate/overview/index.html

               

              The bi-direction thing still worries me some, but if it works it works

               

              Best Regards

               

              mseberg

               

              Message was edited by: mseberg