Mitchell - My knowledge is mostly from reading at this point, but here are some thoughts that a colleague provided from his experience:
- backup and recovery is much more complicated in a replicated environment so it needs to be planned - replicated databases inevitably get out of sync so some process outside the usual replication method must be built to re-sync the databases. this can either be done proactively or reactively - proactive is more fun. - a process to monitor the overall health of the replicated environment is a good idea. i.e. how latent are the transactions, are the replicated transactions actually being replicated, have there been any data conflicts. - schema changes get real fun. planning ahead again a good idea. - additional testing is needed to prove the replication will work especially on the performance front. I have found only two books on replication (is that a hint that most sites avoid it??) Oracle Distributed Systems by Charles Dye, O'Reilly 1999 Data Replication by Marie Buretta, Wiley 1997 -----Original Message----- Sent: Friday, June 14, 2002 11:05 AM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 10:58 AM > We are just starting to look at replication so each manufacturing plant can > have their own server. The applications are being developed in-house. I feel > the first issue is to analyze each table and decide how it will be > replicated and what schema changes need to me made to accommodate > replication. Instead, one of the developers wants to talk to Quest about > their solution. It seems to me that you need to make the same evaluation and > schema changes where needed. If anyone can point me to a white paper on > schema changes to consider, that would be appreciated. > > Dennis Williams > DBA, 20% OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: mitchell INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).