RE: Replication question

... below...

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: 19 June 2002 20:53
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Replication question
>
>
> Peter - I would appreciate a copy of your paper. We are making some
> decisions on whether/how to proceed with replication.
>
> Fun aside, what factors prompted you to create your own
> replication system?

We needed master-master (and therefore maintenance of full referential integrity at all sites) before advanced replication was available. Even now that AR is available, we are not running Enterprise edition, and so that option is not open to us. The basic / snapshot approach simply did not meet our business requirements.

peter
edinburgh
.......

>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, June 19, 2002 11:33 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Just a general comment on replication.
>
> I built an in-house master-master asynchronous system (share Rachel's
> misgivings about synchronous). Its fun, but you have to do a
> lot of very
> careful thinking about what your objectives are, best way to
> implement, and
> then (as already alluded to) ensure you have a reporting
> infrastructure
> (preferably automated) which confirms that what has actually
> happened is
> what you expected and wanted to happen. As a final insurance,
> have a system
> which you can explicitly drive if a) someone wants something
> replicated NOW,
> or b) some sort of recovery is required. And yes, I have used it to
> facilitate migrations, which was like an unexpected bonus.
>
> If anyone wants it, you can see the short paper I presented
> at one of the
> recent European OUG meetings on all the above...
>
> peter
> edinburgh
>
> > -----Original Message-----
> > From: Khedr, Waleed [mailto:Waleed.Khedr_at_FMR.COM]
> > Sent: 15 June 2002 00:03
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Replication question
> >
> >
> > I can say that replication is an application solution level
> > which means you
> > can not turn on the switch to get all the applications/tables
> > replicated
> > while on the other hand Standby database is a database level
> > solution that
> > does not have to know anything about the applications/tables
> > hosted by the
> > database.
> >
> > Regards,
> >
> > Waleed
> >
> > -----Original Message-----
> > Sent: Friday, June 14, 2002 1:41 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Curious, that note suggests Advanced Replication as a failover
> > methodology.
> >
> > Seems that a standby database would be _much_ simpler.
> >
> > Any thoughts ( from anyone ) on why one would use AR for
> > failover, rather
> > than using a standby database?
> >
> > Jared
> >
> >
> >
> >
> >
> > John Weatherman <john.weatherman_at_replacements.com>
> > Sent by: root_at_fatcity.com
> > 06/14/2002 09:50 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: RE: Replication question
> >
> >
> > Mitchell,
> >
> > There are a LOT of good papers in Metalink. I've been
> getting my own
> > education over the last few months. Replication is a really
> > great swiss
> > army knife though, you need to do a little looking for what you
> > specifically
> > need to do, then test, test, test. Oh, and did I mention
> test? :) I
> > found
> > Note: 138181.1 particularly helpful. Oh, and plan on some
> > TARs. I have
> > found Support very helpful/informative in this area.
> >
> > Good Luck,
> >
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> >
> > -----Original Message-----
> > Sent: Friday, June 14, 2002 12:05 PM
> > 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
> > --
> > 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:
> > INET: Jared.Still_at_radisys.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: Khedr, Waleed
> > INET: Waleed.Khedr_at_FMR.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).
> >
>
>
> *********************************************************************
> This e-mail message, and any files transmitted with it, are
> confidential and intended solely for the use of the addressee. If
> this message was not addressed to you, you have received it in error
> and any copying, distribution or other use of any part of it is
> strictly prohibited. Any views or opinions presented are solely those
> of the sender and do not necessarily represent those of the British
> Geological Survey. The security of e-mail communication cannot be
> guaranteed and the BGS accepts no liability for claims arising as a
> result of the use of this medium to transmit messages from or to the
> BGS. The BGS cannot accept any responsibility for viruses, so please
> scan all attachments. http://www.bgs.ac.uk
> *********************************************************************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robson, Peter
> INET: pgro_at_bgs.ac.uk
>
> 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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: Robson, Peter
  INET: pgro_at_bgs.ac.uk

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