AW: Replication Advice Needed
- From: "Stefan Jahnke" <Stefan.Jahnke@xxxxxx>
- To: <cmarquez@xxxxxxxxxxxxxxxx>, <charlottejanehammond@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Sep 2005 15:13:28 +0200
Hi everybody
I'm just facing the same "challenge". I have to keep to instances in
sync and both have to be online. So I figured I'd go with Multi-Master
Replication (tm). All tables are subject to DML, 99% inserts. Are there
any pitfalls to be expected?
Regards,
Stefan
________________________________
Von: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im Auftrag von Marquez, Chris
Gesendet: Freitag, 23. September 2005 17:11
An: charlottejanehammond@xxxxxxxxx; ORACLE-L
Betreff: RE: Replication Advice Needed
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@xxxxxxxxxxxxx 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
