Re: Oracle Stream or Golden Gate?
Date: Thu, 6 Dec 2012 09:29:28 -0500
Message-ID: <CAMVw97Lrb=LQ2BWjjDrwRBrR+canbogEcd_itQYDcDMskWV2UA_at_mail.gmail.com>
I've been using Oracle Streams pretty much from the first version they appeared in 9i and I was using GoldenGate from the time Oracle bought them. Everything below is related to replicating only between Oracle DBs.
In my opinion Streams is a lot more sophisticated and flexibly technology. Unfortunately that played against the technology in a long run as not a lot of folks could get it right. But technology wise GoldenGate is not even close, thought they are improving very fast and it is a very welcome process. Simplicity is in favor of GoldenGate, hands down, and that's what wins it the market and I have no issues with that.
Anybody who says that Streams will not receive new features or will not be further developed... Do you know what GoldenGate Integrated Capture (the latest and hottest GoldenGate 11.2 feature) really is?
On Tue, Dec 4, 2012 at 2:47 PM, Lu Jiang <lu.jiang69_at_yahoo.com> wrote:
> Hi all,
>
> I have to pick one of them - Oracle Stream or Golden Gate for our reporting system (I actually like logical standby since looks we only need an exact copy of prod database for reporting purpose, less maintenance, but it is not an option). The replica reporting db will be a RAC database and reside in the same cluster and same nodes as the prod database.
>
> Have done Oracle multi-master advance replication implementation several years ago, I knew it needs a lot of maintenance. Think Oracle Stream had a lot of improvement but I never tried.
>
> Have read some articles comparing these two replication products. It seems Oracle stream has no future, Oracle Golden Gate is expected to be the main replication method in the future. Also we may use Golden gate for no down time migration.
>
> Could anyone used Oracle Stream and Golden Gate shed some light? Which one is better in terms of deployment and maintenance? Less maintenance is important since we are so busy.
>
> Thanks,
> Lu
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- Alex Fatkulin, http://afatkulin.blogspot.com Enkitec, http://www.enkitec.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 06 2012 - 15:29:28 CET