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

    Oracle Streams vs Oracle Golden Gate

      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 on Linux RH
      Second Server Oracle Database 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.

          • 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
            • 3. Re: Oracle Streams vs Oracle Golden Gate
              Satishbabu Gunukula
              Please refer below links


              hope this helps,

              You want to participate in Oracle Beta program or Exam?
              Could Not Get DeploymentManager When Deploying or Undploying Agile
              • 4. Re: Oracle Streams vs Oracle Golden Gate
                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.