Replication implementation for a newbie.... in 10 days? Having worked on replication for two and half hears, I would say it should not be done.
Replication is way too complex. Read the Anita Badreen's white paper and it would emphasize the importance of understanding and planning repliction. There are several good white papers / notes on replication too on metalink. >From my expereience, I would say, read Oracle Manual for Replication 2-3 times atleast. If you want to be good at it, come to the stage where you can do it without GUI (so that you know it pretty well.) They say that Replication Manager GUI is very good. But I have never felt need to use it, except, some basic monitoring... Practice, practice, practice.... Understand exactly needs of application very well and then decide what kind of replication to use.... HTH, -Rachna ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 11:43 AM > > > and, if possible, start with Anita Bardeen's white paper "Replication DOs > and DON'Ts". (You'll probably find it at OTN). This is only a few pages, > but it's full of invaluable tips. > > Barb > > > ---------- > > From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Monday, October 14, 2002 8:58 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Replication > > > > Robin > > Your management sounds like some people I dealt with that assumed they > > would just "flip the replication switch". How much of the 30-gig. do they > > plan to replicate? What replication interval? What tools do they plan to > > use? What is the replication direction - master-slave, peer-peer? How many > > sites? Ask for a copy of their replication policies. How will replication > > problems be detected? How will they be rectified? > > For reading, I would recommend what are the only 2 books I could locate > > (does that give you a hint about the popularity of replication?) > > Data Replication, Marie Buretta (lots of information about why policies > > are vital and how to write them). > > Oracle Distributed Systems, Charles Dye. > > The key to replication success (I can only speak from book knowledge) is > > in > > the people and the policies that coordinate their efforts and ensure > > nothing > > is overlooked, not in the technology. > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -----Original Message----- > > Sent: Monday, October 14, 2002 8:58 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi all, > > > > Does anyone have the appropriate time on implementing replication for a > > newbe? > > > > I am given a time frame on doing the replication for 10 days which is > > including testing on test server and move to production. I've never done > > that before, now just start reading. This DB is about 30G on Oracle > > 8.1.7. > > > > TIA > > > > Robin > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Robin Li > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > 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 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > 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: Baker, Barbara > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).