4 Replies Latest reply: May 5, 2012 4:33 AM by Ilmar.Kerm RSS

    Oracle Streams vs Oracle Golden Gate

    935140
      We are in the process of creating a reporting server (replica) for our production environments. I was considering Oracle streams and Oracle Golden Gate. I read a lot about both technologies and they both satisfy our demands for a reporting server.
      I just want to know if anybody else had the same experience and what was the final choice and the rationale behind it?

      Environment is as below:
      First server Oracle Database 11.2.0.2.0 on Linux RH
      Second Server Oracle Database 10.2.0.5.0 on Windows 2003

      Both servers will live on Linux RH as a separate servers.
        • 1. Re: Oracle Streams vs Oracle Golden Gate
          Srini Chavali-Oracle
          I have no experience with Streams, but GG requires a separate license (which can be expensive), so your solution choice may come down to how much you are willing (or not) to spend.

          HTH
          Srini
          • 2. Re: Oracle Streams vs Oracle Golden Gate
            Iordan Iotzov
            Golden Gate is a “Strategic” replication solution, while Streams are in “Continue & Converge” mode -
            http://www.oracle.com/technetwork/middleware/goldengate/overview/statement-of-direction-gg-132120.pdf (page 11).

            I do not know what the practical impact of this policy is though.

            Iordan Iotzov
            http://iiotzov.wordpress.com/
            • 3. Re: Oracle Streams vs Oracle Golden Gate
              Satishbabu Gunukula
              Please refer below links

              http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3349335100346299316
              http://cglendenningoracle.blogspot.com/2010/02/streams-vs-golden-gate.html
              http://www.dbasupport.com/oracle/ora11g/Oracle-Replication-Streams-vs-GoldenGate.shtml

              hope this helps,

              Regards
              http://www.oracleracexpert.com
              You want to participate in Oracle Beta program or Exam?
              http://www.oracleracexpert.com/2012/01/you-want-to-participate-in-oracle-beta.html
              Could Not Get DeploymentManager When Deploying or Undploying Agile
              http://www.oracleracexpert.com/2012/02/could-not-get-deploymentmanager-when.html
              • 4. Re: Oracle Streams vs Oracle Golden Gate
                Ilmar.Kerm
                I have only used Streams, because if you are running on Enterprise Edition from the source side, then Streams is included in the database price, apply side can be standard edition also.
                In Streams its very easy to exclude specific transactions from replication (using tags), i've heard its much more complex task in goldengate.

                Streams can be a pain to set up, but when it is working, its working well.