Oracle Stream or Golden Gate?
From: Lu Jiang <lu.jiang69_at_yahoo.com>
Date: Tue, 4 Dec 2012 11:47:28 -0800 (PST)
Message-ID: <1354650448.60529.YahooMailNeo_at_web120005.mail.ne1.yahoo.com>
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
Date: Tue, 4 Dec 2012 11:47:28 -0800 (PST)
Message-ID: <1354650448.60529.YahooMailNeo_at_web120005.mail.ne1.yahoo.com>
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-lReceived on Tue Dec 04 2012 - 20:47:28 CET