This discussion is archived
10 Replies Latest reply: Mar 9, 2012 7:26 AM by 735967 RSS

Step by Step guide to implement Active Dataguard 11g

735967 Newbie
Currently Being Moderated
Hi All,

Please suggest a good step by step guide to implement Oracle Active Dataguard on Oracle 11g, OS : RHEL 5.4

Have searched a couple of documents, but ending up with physical or logical dataguard setup guides...

Please suggest end to end steps guide for Active Dataguard Implementation

DB : Oracle 11g Release 2
OS : RHEL 5.4

Thanks
  • 1. Re: Step by Step guide to implement Active Dataguard 11g
    CKPT Guru
    Currently Being Moderated
    user1687821 wrote:
    Hi All,

    Please suggest a good step by step guide to implement Oracle Active Dataguard on Oracle 11g, OS : RHEL 5.4

    Have searched a couple of documents, but ending up with physical or logical dataguard setup guides...

    Please suggest end to end steps guide for Active Dataguard Implementation

    DB : Oracle 11g Release 2
    OS : RHEL 5.4

    Thanks
    Hi,

    Active dataguard is option after configuring dataguard.
    You can put standby database in Open(read only) mode also you can enable Recover(MRP) while open so this can be used for reporting purpose too.
    Please refer below links for configuring them.

    http://www.oracle-class.com/wp-content/uploads/2011/01/dataguard/11gR2%20Physical%20Data%20Guard%20Setup%20%20project,%20with%20Active%20Data%20Guard%20option.pdf
    http://www.databasejournal.com/features/oracle/article.php/3834931/Using-Oracle-11gs-Active-Data-Guard-and-Snapshot-Standby-Features.htm

    http://www.oracle-base.com/articles/11g/DataGuardSetup_11gR2.php
    http://www.oracle.com/technology/deploy/availability/pdf/maa_wp_11gr1_activedataguard.pdf

    HTH.
  • 2. Re: Step by Step guide to implement Active Dataguard 11g
    Talip Hakan Ozturk Oracle ACE
    Currently Being Moderated
    You can find here

    http://taliphakanozturken.wordpress.com/2011/06/26/creating-standby-database-with-rman-active-database-duplication-in-11gr2/



    Talip Hakan Ozturk
    http://taliphakanozturken.wordpress.com/
  • 3. Re: Step by Step guide to implement Active Dataguard 11g
    Shivananda Rao Guru
    Currently Being Moderated
    Refer
    http://oracleinnotiive.wordpress.com/2010/01/26/how-to-setup-11g-active-dataguard/
    http://dbastreet.com/blog/?tag=11g-active-dataguard
    http://www.oracle-class.com/?p=1428
  • 4. Re: Step by Step guide to implement Active Dataguard 11g
    735967 Newbie
    Currently Being Moderated
    Thanks to one and all...

    I will go through the links

    Thanks
  • 5. Re: Step by Step guide to implement Active Dataguard 11g
    UweHesse Expert
    Currently Being Moderated
    Before going into any technical details (Blog posting or Documentation), just make sure to get the terminology right at first:

    1) in 11g, you can create the Standby without using a backup with the RMAN command:

    >
    RMAN> duplicate target database for standby from active database;
    >

    This is not Active Data Guard but just a new way to do the duplicate.

    2) in 11g, you can have a Physical Standby in READ-ONLY OPEN mode while the Redo Apply (actualization) is still done.

    That feature is called Real-Time Query and requires the (extra charged) Active Data Guard Option .
    It is really simple and no effort at all to use that feature after you have implemented the Physical Standby

    Kind regards
    Uwe Hesse

    http://uhesse.wordpress.com
  • 6. Re: Step by Step guide to implement Active Dataguard 11g
    735967 Newbie
    Currently Being Moderated
    Hi Uwe Hesse,

    Thanks for the valuable information and reply...

    Converting the Physical standby and making it readonly is a feature already adopted by logical standby... (Correct me if iam wrong)

    So what is the advantage of Active Dataguard then...

    Please clarify...

    Thanks
  • 7. Re: Step by Step guide to implement Active Dataguard 11g
    mseberg Guru
    Currently Being Moderated
    Hello;

    With Active Data Guard you have an exact copy of the Primary database.

    In a logica Data Guard setupl some data types are not supported.

    Better failover and switchover options with pure Physical.

    The ability to open the database read-only and still meet the RTO and RPO objectives.

    The Standby is 100 percent available for failover and switchover.

    Fast incremental backups.

    Best Regards

    mseberg
  • 8. Re: Step by Step guide to implement Active Dataguard 11g
    Talip Hakan Ozturk Oracle ACE
    Currently Being Moderated
    user1687821 wrote:
    Hi Uwe Hesse,

    Thanks for the valuable information and reply...

    Converting the Physical standby and making it readonly is a feature already adopted by logical standby... (Correct me if iam wrong)

    So what is the advantage of Active Dataguard then...

    Please clarify...

    Thanks
    Active Dataguard is the feature that standby database can be open in read-only mode while redo apply (Read-Only with Apply). Therefore, the database is called the Active Standby. If we look at in terms of benefits to us of the Active Data Guard; We can make our real-time reporting (while continuing to apply redo),backup operations through the active standby database.Thus, we will reduce the processing load of production.



    Talip Hakan Ozturk
    http://taliphakanozturken.wordpress.com/
  • 9. Re: Step by Step guide to implement Active Dataguard 11g
    735967 Newbie
    Currently Being Moderated
    Hi mseberg ,

    Thank you listing the features

    Thanks
  • 10. Re: Step by Step guide to implement Active Dataguard 11g
    735967 Newbie
    Currently Being Moderated
    Hello Talip Hakan Ozturk,

    Thanks for replying

    Thanks