From oracle-l-bounce@freelists.org Mon Sep 26 08:17:03 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8QDH1xe030497 for ; Mon, 26 Sep 2005 08:17:01 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8QDGo6H030461 for ; Mon, 26 Sep 2005 08:16:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D374D1EC6F4; Mon, 26 Sep 2005 08:16:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30342-03; Mon, 26 Sep 2005 08:16:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 49EF31E0BAC; Mon, 26 Sep 2005 08:16:46 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C29C.15906F44" Subject: AW: Replication Advice Needed Date: Mon, 26 Sep 2005 15:13:28 +0200 Message-ID: <87F172BCF111D0489340AB3CB16A011E0113D863@EBMS20.bov.int> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Replication Advice Needed Thread-Index: AcXATvNjfSbezw58TJ2nUZffVkTzGQAANil+AJL7OQA= From: "Stefan Jahnke" To: , , "ORACLE-L" X-archive-position: 25880 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Stefan.Jahnke@bov.de Precedence: normal Reply-To: Stefan.Jahnke@bov.de X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=BAYES_00, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5C29C.15906F44 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi everybody =20 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? =20 Regards, Stefan =20 ________________________________ Von: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] Im Auftrag von Marquez, Chris Gesendet: Freitag, 23. September 2005 17:11 An: charlottejanehammond@yahoo.com; ORACLE-L Betreff: RE: Replication Advice Needed =20 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@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 =20 __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l ------_=_NextPart_001_01C5C29C.15906F44 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable RE: 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 ™. All tables are subject to DML, 99% = inserts. Are there any pitfalls to be expected?

 

Regards,

Stefan

 


Von: = oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] Im Auftrag von Marquez, Chris
Gesendet: Freitag, 23. = September 2005 17:11
An: charlottejanehammond@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@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.o= rg/webpage/oracle-l

------_=_NextPart_001_01C5C29C.15906F44-- -- http://www.freelists.org/webpage/oracle-l