Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Advanced Replication

RE: Oracle Advanced Replication

From: Peter Barnett <regdba_at_yahoo.com>
Date: Fri, 15 Feb 2002 09:48:48 -0800
Message-ID: <F001.004112EC.20020215093450@fatcity.com>

This is a project being managed by outside consultants. Their original request was to have two servers each with databases installed. One of these servers was to be shut down sitting next to the primary server. If one failed, fire up the second server, switch the network connection and start the database. Somehow, this did not quite seem right!

We finally agreed to try replication.
--- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> 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

>

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


Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com

Do You Yahoo!?
Got something to say? Say it better with Yahoo! Video Mail http://mail.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).
Received on Fri Feb 15 2002 - 11:48:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US