Oracle-L: RE: Replication question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 19 Jun 2002 11:52:57 -0800
Message-ID: <F001.00481C59.20020619115257@fatcity.com>

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?

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

Received on Wed Jun 19 2002 - 14:52:57 CDT