This discussion is archived
3 Replies Latest reply: Sep 16, 2011 2:12 AM by emre baransel RSS

Data Guard Vs Golden Gate

862878 Newbie
Currently Being Moderated
Hi Experts,

I am looking for High Availability 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 20 miles.

Site 1:
---------

We already implemented RAC setup with two node in site 1.

Site 2:
---------

We are going to implement standalone database. (Not RAC)


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. Site 1 is active and Site 2 is stand by.

4. Client applications on Site 1 & Site 2 should always talk to RAC database on Site1.

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


How can acheive 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
  • 1. Re: Data Guard Vs Golden Gate
    Kashif M Oracle ACE
    Currently Being Moderated
    Please check following links, i hope you will get your answers.
    reply of Tom:
    http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:3349335100346299316

    Dataguard Active/Active Vs Golden gate in 11i environment

    http://www.oracle.com/technetwork/database/features/availability/dataguardgoldengate-096557.html
  • 2. Re: Data Guard Vs Golden Gate
    mseberg Guru
    Currently Being Moderated
    1. Do Data Guard and Golden Gate offers same features ?
    No, there's simple compare here :

    http://www.oracle.com/technetwork/database/features/availability/dataguardgoldengate-096557.html
    2. Which products offers solutions to all my requirements or Do I need to use both ?
    Data Guard will work and you don't need anything else. I cannot speak to Golden Gate.
    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 ?
    Again this document :

    http://www.oracle.com/technetwork/database/features/availability/dataguardgoldengate-096557.html

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

    Data Guard can do this.


    2. Both databases should be in sync always.

    Data Guard can do this.

    3. Site 1 is active and Site 2 is stand by.

    Data Guard can do this.

    4. Client applications on Site 1 & Site 2 should always talk to RAC database on Site1.

    You can set your tnsnames to handle this and more. Using DBMS_SERVICE you can create an alias
    to handle this.

    Ex.
    ernie =
     (DESCRIPTION =
        (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = primary.host)(PORT = 1521))
           (ADDRESS = (PROTOCOL = TCP)(HOST = standby.host)(PORT = 1521))
           )
           (CONNECT_DATA =
           (SERVICE_NAME = ernie)
        )
     )
    5. If RAC at site 1 goes down completely, then ONLY client apps should connect to Site2 database without human intervention.

    You can set your tnsnames to handle this and more.

    Best Regards

    mseberg
  • 3. Re: Data Guard Vs Golden Gate
    emre baransel Employee ACE
    Currently Being Moderated
    Hi as mseberg said, data guard offers solutions to all your requirements.

    Data guard physical standby is a block copy of primary (golden gate is not) and the best way for disaster recovery.

    Please check data guard options "Maximum Availability" , "Maximum Performance" and "Maximum Protection" and chose which fits you best.
    http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/protection.htm

    You must use real-time recovery for the fastest failover. and please check Uwe's post for faiilover without human intervention.
    http://uhesse.wordpress.com/2009/08/19/connect-time-failover-transparent-application-failover-for-data-guard/

    regards

Legend

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