7 Replies Latest reply: Mar 9, 2012 9:44 AM by user10201249 RSS

    Data Guard vs GoldenGate vs  Streams?

    user10201249
      Hi,
      What's the difference between Active Data Guard , Golden Gate and Streams ?
      what best practices for DR & reporting in EBS ?
      EBS not support active Data Guard (Logical Standby)
      Regards
      Hany
        • 1. Re: Data Guard vs GoldenGate vs  Streams?
          Talip Hakan Ozturk
          You can find brief information about data guard (also active data guard) in this doc.

          http://taliphakanozturken.wordpress.com/2011/06/16/brief-information-about-the-oracle-data-guard/


          Talip Hakan Ozturk
          http://taliphakanozturken.wordpress.com/
          • 2. Re: Data Guard vs GoldenGate vs  Streams?
            user10201249
            Thanks Talip,
            thanks for relpy ,
            I need to compare between Data Guard , GoldenGate and Streams ?
            thanks for help in data guard
            Regards
            Hany
            • 3. Re: Data Guard vs GoldenGate vs  Streams?
              mseberg
              Hello;

              You might want to look at Oracle 11g Streams for DBMS_COMPARISON.

              http://download.oracle.com/docs/cd/B28359_01/server.111/b28322/man_comp.htm#STREP148

              OR

              http://cglendenningoracle.blogspot.com/2010/02/streams-vs-golden-gate.html

              OR

              DataGuard vs Stream / Advanced Replication


              Ask Tom

              Data guard vs Streams vs GoldenGate", version 11.2.0.2

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

              Best Regards

              mseberg
              • 4. Re: Data Guard vs GoldenGate vs  Streams?
                CKPT
                What's the difference between Active Data Guard , Golden Gate and Streams ?
                Active dataguar option even comes with enterprise edition, it's an image copy of primary/production database.
                Goldengate is a third party tool where you can replicate between heterogeneous databases like oracle to SQL server or any other.

                Streams is a replication, you can refresh data using streams.

                These all three topics cover under replication
                But which feature you want to use , depends on cost and critical I can say.
                what best practices for DR & reporting in EBS ?
                You can use physical standby with active dataguard option, it's feature of 11g.
                EBS not support active Data Guard (Logical Standby)
                This question is not feasible. I mean logical standby database is itself for reporting. Still what active dataguard you looking for?
                Active dataguard is option of physical standby where database can be opended to perform read operations & also recovery will be in progress. In case of logical standby even earlier releases it will be used as reporting purpose.
                • 5. Re: Data Guard vs GoldenGate vs  Streams?
                  user10201249
                  Hi,
                  thanks for clarification ,
                  about
                  EBS not support active Data Guard (Logical Standby)

                  In the doc,
                  Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database [ID 1070033.1]
                  Note: Logical standby databases are not supported with Oracle E-Business Suite standard functionality.

                  SQL>alter database recover managed standby database cancel;
                  SQL>alter database open read only;

                  how I can use STBY database in reporting while it is in mount mode?

                  also may be I am confused but How I made standby Database in reporting ?

                  regards & thanks
                  Hany
                  • 6. Re: Data Guard vs GoldenGate vs  Streams?
                    Seberg
                    Please close your question when complete.
                    • 7. Re: Data Guard vs GoldenGate vs  Streams?
                      user10201249
                      Thanks for help