Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10g - multi-master-replication vs Streams

Re: 10g - multi-master-replication vs Streams

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 28 Apr 2007 11:33:13 -0700
Message-ID: <1177785192.672826@bubbleator.drizzle.com>


Curious wrote:
> Hi all,
>
> we are planning to upgrade 9.2.0.8 to 10.2.0.3.
>
> On our old environment we have had four separate instances and multi-master
> replication setup.
>
> Now when moving to 10.2.0.3 there might be a chance to start using Oracle
> Streams. Would it be worth it.

Yes.

> - is it easier to setup

Yes.

> - is it easier to maintain/monitor

Yes.

> - any other benefits using streams

Less time spent evening and weekends at work.

But before choosing Streams explore whether Change Data Capture will work. It is easier to set up and will handle many situations.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Apr 28 2007 - 13:33:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US