| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AW: Replication Advice Needed
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Marquez, Chris
Gesendet: Freitag, 23. September 2005 17:11
An: charlottejanehammond_at_yahoo.com; 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_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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 26 2005 - 08:17:03 CDT
 |
 |