1 Reply Latest reply: Jul 14, 2014 9:48 PM by Nip-Oracle RSS

    Active Data Guard Vs Oracle Golden Gate

    c47d8073-1096-49dd-a190-24d898b15997

      Hi Experts,

       

      I am looking for High Availability, Load balancing/sharing and Disaster Recovery architecture for my data layer i.e. Oracle Database 11g R2.

       

      We have two physical locations and the distance between two sites is around 55 miles.

       

       

      Site 1:

      ---------

       

       

      We already implemented standalone database in site 1.

       

       

      Site 2:

      ---------

       

       

      We are going to implement standalone database.

       

       

       

      My requirements:

      -----------------------

       

       

      1. Both databases at Site 1 & Site 2 should be replica of each other.

       

       

      2. Both databases should be in sync always.

       

       

      3. Client applications for Operations on Site 1 & Site 2 should always talk to database on Site1.

       

       

      4. Client Reporting on Site 1 & Site 2 should always talk to database on Site2.

       

       

      5. If DB at site 1 goes down completely, then ONLY client apps should connect to Site2 database without human intervention.

       

       

      6. If DB at site 2 goes down completely, then ONLY client apps should connect to Site1 database without human intervention.

       

       

      How can achieve my requirement ? I was doing some research & found two solutions. 1. Active Data Guard 2. Golden Gate.

       

       

      Questions:

       

       

      1. Do Data Guard and Golden Gate offers same features ?

       

       

      2. Which products offers solutions to all my requirements or Do I need to use both ?

       

       

      3. If Data Guard and Golden Gate are different from each other then What is the difference between them and what are the overlapping features among them ?

       

       

      Thanks.

      Wajahat Qureshi

        • 1. Re: Active Data Guard Vs Oracle Golden Gate
          Nip-Oracle

          1. Do Data Guard and Golden Gate offers same features ?

           

          ==)> The main difference between them is that Golden Gate can work across different versions and in fact across different O/S platform.

           

          2. Which products offers solutions to all my requirements or Do I need to use both ?

           

          ==)> Both works. However, if you have same platform/db version, Active Data Guard is better option, as this can also server you as pure DR site.

           

          3. If Data Guard and Golden Gate are different from each other then What is the difference between them and what are the overlapping features among them ?

           

          ==)> Difference is mentioned in #1 above and main overlapping feature is that both are 'replication' solutions.