Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Replication Question

Re: Replication Question

From: Yechiel Adar <adaryechiel_at_hotmail.com>
Date: Wed, 10 Apr 2002 08:33:37 -0800
Message-ID: <F001.00440BA4.20020410083337@fatcity.com>


Hello John

We are doing master to master replication. Both are 8.1.6 on NT.

When we need to rebuild we delete and create both databases and import the data into both.

Then we run a script that dynamically generate the proper procedure calls for all the tables in the schema and run them.

I think that the trick is using copy_rows => false so the replication does not
copy all the data again.

Note 120686.1 is quite correct.

However I used scripts for all the work. Gave the script to the application supervisor and he runs it whenever he rebuilds the databases (also scripts).

The process is long (some hours) as we have about 500 tables to build replication for.

One more point: The docs talk about replication manager user, propagator user
and receiving user. We used repadmin for all the functions.

Yechiel Adar
Mehish

> Hi All,
>
> I have recently been handed the task of setting up master-master
> replication on our existing production environment (yes, I am in
> test to start!). Because this is an established site with a lot
> of historical data, we would like to use Offline Instantiation
> as detailed in Note 68657.1. We had an Oracle Consultant in here
> who said this was the best approach.
>
> However as I started digging, I discovered Note 120686.1, which
> indicates that the other note only really applies when adding a
> new master to an existing replicated system. Problems with
> referential integrity seem to blow the note apart when working with
> an existing, non-replicated production system.
>
> SO, my question is, has anybody successfully managed offline
> instantiation for converting an existing non-replicated system into
> a master-master replicated system? How did you deal with the
> constraints issue?
>
> Of course this is made even more complicated by having the original
> master be an 8i instance and the new master be a 9i instance. I'm
> thinking that setting the 9i compatable init parameter to match the
> 8i instance should allow things to work. Any experience running a
> replicated master-master system with differing version of Oracle for
> the masters? Any special gotchas I should be aware of?
>
> Thanks for any and all help!
>
> Pax,
>
> John
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
> INET: john.weatherman_at_replacements.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adaryechiel_at_hotmail.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 Wed Apr 10 2002 - 11:33:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US