Re: Replication

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" <ORACLE-L_at_fatcity.com> 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:DWILLIAMS_at_LIFETOUCH.COM]
> > Reply To: ORACLE-L_at_fatcity.com
> > 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.
> > dwilliams_at_lifetouch.com
> >
> > -----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: rli_at_nyp.org
> >
> > 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: 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: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > 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: 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: Baker, Barbara
> INET: bbaker_at_denvernewspaperagency.com
>
> 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: 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: Rachna Vaidya
  INET: rachnavaidya_at_hotmail.com

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