Re: multimaster replication

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Thu, 09 Aug 2001 16:41:58 -0700
Message-ID: <F001.00365D54.20010809091927@fatcity.com>

Andrey,

Don't even think about implementing this until you've read the manuals and thoroughly understand the concepts. Replication can be very unforgiving when you don't properly design and configure it. You may also find that your application is not even suited for it.

> - Is it a must for the 2 DBs to be of the same
> version (release) ?
> - Is it a must for the 2 DBs to run on the same
> O/S, hardware etc ... ?

  NO, to all of the above. One of replication's strength's is that it is Oracle, OS and hardware version independent. Personally, I wouldn't even try implementing it on Oracle7 and given a choice I'd use 8i or 9i. Any combination of currently supported versions will work just fine.

I'd start with reading the Oracle Distributed, Replication, and Replication API manuals.

I also like Charles Dye's "Oracle Distributed Systems" (O'Reilly).

My "Replication Do's and Don'ts" paper is available on Christopher Spence's site:
http://www.vampired.net/articles/files/replication1.zip

Good luck!

• Anita
  • Andrey Bronfin <andreyb_at_elrontelesoft.com> wrote:
    > Dear gurus !
    > Finally , they caught me ;-(
    > I need to implement multimaster replication
    > (asynchronous) among 2
    > databases.
    > A couple of general questions before i start :
    > - Is it a must for the 2 DBs to be of the same
    > version (release) ?
    > - Is it a must for the 2 DBs to run on the same
    > O/S, hardware etc ... ?
    > - Do U have to replicate among 2 schemas with the
    > same names ?
    > - Are there any general bugs / issues ? Something
    > to be aware of ?
    > - And , the most important , i'd be very happy if u
    > , gurus , could send me
    > some scripts , how-tos , manuals , articles , your
    > thoughts - simply
    > anything related to advanced replication.
    > Many thanks in advance.
    > Andrey.
    >
    >
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: Andrey Bronfin
    > INET: andreyb_at_elrontelesoft.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >

    ---

    
    > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > (or the name of mailing list you want to be removed
    > from). You may
    > also send the HELP command for other information
    > (like subscribing).
    

    ---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Aug 09 2001 - 18:41:58 CDT