RE: Oracle Advanced Replication

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 15 Feb 2002 08:18:25 -0800
Message-ID: <F001.0041104B.20020215073329@fatcity.com>

Peter - Since nobody seems to be answering your question, I guess you get the second tier here. I have not used Oracle Replication, but I have studied it some. The first thing I seem to always hear about Oracle's Replication is that you must be careful or it won't be able to keep up. The other thing they point out is that the application must be designed for replication, but I'm not sure this applies in the failover application you describe. But it could get messy since you must configure replication on each of your tables. I know that the Replication advocates mention how it can be used for a standby database, and if you had an offsite disaster recovery site, I would say Replication would be worth a look.

What you are proposing sounds a lot like Oracle9i's new Real Application Clusters (RAC), or Oracle's Standby database. Another idea if you insist on replication would be to look at Quest's SharePlex.

In the worst case, maybe my reply will encourage someone with replication experience to reply.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L

We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data.

Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into?

Thanks

Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com

Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Peter Barnett
INET: regdba_at_yahoo.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: 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
--------------------------------------------------------------------