Re: Replication Advice Needed

Go with Streams. It works quite well. It is also faster than AR, and easier to setup.
For initial setup check Sanjay Mishra's
http://www.oracle.com/technology/oramag/oracle/04-nov/o64streams.html  Ranko.

 On 9/23/05, Sandeep Dubey <dubey.sandeep_at_gmail.com> wrote:
>
> Charlotte,
> If there is no DML at remote database use MM and your life is very easy.
> If there will be DML at remote you have choice of using multi master
> AR or streams. Choose one where you are more confident. If I have to
> learn both, it would be streams.
>
> The Streams architecture is lot more flexible than Oracle
> Replication's. This leads me to suspect that Oracle will be pushing
> Streams over Replication in subsequent releases, so I would expect new
> features in Streams, like DDL changes, that aren't in Oracle
> Replication. Realistically, though, I don't expect any serious
> movement away from Replication for at least a few releases, so I
> wouldn't tend to be overly concerned on this front.
>
> Streams replication is log based. Capture process catpures DDL and DML
> changes. So no additional overhead on user transactions. (Mutil maser
> uses internal trigger and this will get fired for each DML. There's a
> slight overhead on user transactions)
>
> Oracle Replication is a significantly more mature product-- it is
> quite usable with older databases. Oracle Streams is a much newer
> technology and is only usable among different 9i or higher databases.
> Most competent Oracle developers and DBA's are familiar with Oracle
> Replication, while many fewer have any real experience with Streams.
>
> Regards
> Sandeep
>
>
>
> On 9/23/05, Marquez, Chris <cmarquez_at_collegeboard.org> wrote:
> >
> >
> > Charlotte,
> >
> > Very quickly...
> >
> > I would use Multi Master Advanced Replication for this.
> > Multi Master Replication is perfect for "small-ish / low-volume tables"
> > with little dependencies where data changes happen infrequently and
> > on one database MOST/ALL of the time
> >
> > I would stay far away from "synchronous" Replication...just run
> > the "push" and "purge" jobs say every five minutes...unless you
> > really need real time changes at both ends.
> >
> > Having sad all of this I have no real experience with Streams and
> > maybe some here will say that it is just as well.
> >
> > If you go with Multi Master Replication I can send you some personal
> notes.
> >
> > Be forewarned that Multi Master Advanced Replication is not with
> administration head aches as is *ANY* transaction based data synchronization
> option/tool.
> >
> >
> > hth
> >
> > Chris Marquez
> > Oracle DBA
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org on behalf of Charlotte Hammond
> > Sent: Fri 9/23/2005 10:55 AM
> > To: ORACLE-L
> > Subject: Replication Advice Needed
> >
> > Hi All,
> >
> > We need to keep 5 (small-ish / low-volume) tables on a
> > remote database in sync with those in the local
> > database. We want synchronous updates of the remote
> > tables when the network allows but we also want to
> > apply queued transactions after recovery from a
> > network failure such that no transactions are ever
> > lost (assuming the local database to be "unbreakable"
> > :-)
> >
> > I'm thinking of advanced replication or streams but
> > unfortunately I don't have any experience in either.
> > I know this is going to require lots of reading and
> > experimenting but I was hoping to short-circuit this
> > by at least focusing on the right technology to start
> > with!: what sounds like the best fit - AR or streams?
> > (This is on 10g)
> >
> > Thank you all in advance for any help
> >
> > Charlotte
> >
> >
> >
> >
> >
> > __________________________________
> > Yahoo! Mail - PC Magazine Editors' Choice 2005
> > http://mail.yahoo.com
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org on behalf of Charlotte Hammond
> > Sent: Fri 9/23/2005 10:55 AM
> > To: ORACLE-L
> > Subject: Replication Advice Needed
> >
> > Hi All,
> >
> > We need to keep 5 (small-ish / low-volume) tables on a
> > remote database in sync with those in the local
> > database. We want synchronous updates of the remote
> > tables when the network allows but we also want to
> > apply queued transactions after recovery from a
> > network failure such that no transactions are ever
> > lost (assuming the local database to be "unbreakable"
> > :-)
> >
> > I'm thinking of advanced replication or streams but
> > unfortunately I don't have any experience in either.
> > I know this is going to require lots of reading and
> > experimenting but I was hoping to short-circuit this
> > by at least focusing on the right technology to start
> > with!: what sounds like the best fit - AR or streams?
> > (This is on 10g)
> >
> > Thank you all in advance for any help
> >
> > Charlotte
> >
> >
> >
> >
> >
> > __________________________________
> > Yahoo! Mail - PC Magazine Editors' Choice 2005
> > http://mail.yahoo.com
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l