10 Replies Latest reply: Mar 9, 2012 9:26 AM by 735967 RSS

    Step by Step guide to implement Active Dataguard 11g

    735967
      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
          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
            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
              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
                Thanks to one and all...

                I will go through the links

                Thanks
                • 5. Re: Step by Step guide to implement Active Dataguard 11g
                  UweHesse
                  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
                    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
                      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
                        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
                          Hi mseberg ,

                          Thank you listing the features

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

                            Thanks for replying

                            Thanks