Re: Oracle Stream or Golden Gate?
Date: Thu, 6 Dec 2012 17:41:11 +0000
Message-ID: <CANx=q_YsJfXY39AUwrjqPT+c+EdFP1xgAynfAsP-ERXaW8qK6Q_at_mail.gmail.com>
I don't really know GoldenGate ell, but i've been working with Streams lately and i agree in one thing with Alex: It is flexible and sophisticated, but that comes with a price and Streams can very complex when you start handling conflict resolution or resync databases on multi-database replication environments or digging inside LCR to discover old-new values... There are some limitations also (just like every product) but not having the possibility to replicate sequences current value is for sure the worst one.. (i think GG can do it). Regarding new features, GG is receiving Streams features and that doesn't mean that Streams will be improved in the future. We just need to wait for 12c :-)
Regards,
Luís Marques
On Thu, Dec 6, 2012 at 2:29 PM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:
> 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-l
>
>
>
-- Cumprimentos, Luís Marques -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 06 2012 - 18:41:11 CET