Re: Oracle Stream or Golden Gate?
- From: Bobby Curtis <curtisbl@xxxxxxxxx>
- To: lu.jiang69@xxxxxxxxx
- Date: Tue, 04 Dec 2012 14:57:37 -0500
Lu,
Good question. I have pulled away from Oracle Streams and gone more
towards Golden Gate. Depending on what you want to do with Golden Gate,
it is the better solution. Deploying Golden Gate for just a disaster
recovery or migration purposes is fairly quick unless you need to
replicate DDL statements (simple but takes a little longer). Golden
Gate is flexible and can be used for many different use cases.
There is always maintenance with any technology you choose to go with.
Golden Gate, I've found it mostly to be based on the needs of the end
user. Trail files could take some filesystem space if not applied
quickly or the extract/replicat processes abend. Overall, I would say
that Golden Gate would provide less maintenance.
I'll answer any questions you might have if more details are needed.
Just let me know.
Regards
Bobby L. Curtis
(e): curtisbl@xxxxxxxxx | (t): @curtisbl294
http://dbasolved.com
On 12/4/2012 2:47 PM, Lu Jiang 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
