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 22.214.171.124.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.
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.
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
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.