Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

10g - multi-master-replication vs Streams

0 views
Skip to first unread message

Curious

unread,
Apr 28, 2007, 12:27:18 AM4/28/07
to
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.
- is it easier to setup
- is it easier to maintain/monitor
- any other benefits using streams

Amount of data is not huge.

Besides of replication/streams is there any other options to "replicate"
data between these four instances.

Thank you in advance

K


DA Morgan

unread,
Apr 28, 2007, 2:33:13 PM4/28/07
to
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
damo...@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Curious

unread,
Apr 29, 2007, 12:39:37 AM4/29/07
to

"DA Morgan" <damo...@psoug.org> wrote in message
news:11777851...@bubbleator.drizzle.com...

Thank you for comments, looks like that I will setup test environment in
order to test Streams...

Cheers
jb


0 new messages