Re: Replication ??

Hi,

it depends on what kind of replication you want. We're using "normal" snapshots (read only and updatable) and multi master replication.
There is an organisational issue concerning multi master replication. You have to be sure about how you want to replicate. We went with asynchronous replication, because that way, it doesn't have an impact on instance A if instance B is down or can't be reached for some other reason. If you have synchronous replication and you're doing an update on instance A while instance B is gone, your application that tries the update might hang, since instance A tries to fire the trigger to do the update in instance B immediately within the same transaction. Also, there are several different ways of conflict resolution. You might want to take a look at this.
Once you have everything running, write some scripts to deal with the errors before they pile up.

Denham Eva schrieb:
>
> Hi Gurus
>
> We are considering implementing replication, on our server.
> Microsoft 2000 Oracle 816.
> Does anyone know of any problems, or "I wish I had known that before....."
> type of issues of doing this?
>
> Many Thanks
> Denham
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Denham Eva
> INET: EvaD_at_TFMC.co.za
>
> 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).
>
> ---------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted mails can NOT be checked!
>
> **
>
> Diese Mail wurde auf Viren geprueft
> Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
> ---------------------------------------------------------

-- 
 ----------------------------
| Regards,                   |
| Stefan Jahnke              |
| BOV AG                     |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893        |
 ----------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.de

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).