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: best hot standby solution

Re: best hot standby solution

From: Danut Bancea <danut_at_telepages.ca>
Date: Thu, 24 Aug 2000 18:00:36 -0400
Message-Id: <10599.115515@fatcity.com>


You can use two database replicated and use load balancing and failover on SQL*Net configuration.

When one database is down the connection from the web is going to the up database.

The bad part is when you put the database up you need to reboot the web server (Oracle Application Server).

There are some downtime for replication configuration (for insert/update/delete) when the replication group is suspended. This time can be short if you create many replication groups for different table based on the application logic.

Danut,



Danut Bancea
Oracle DBA

Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca


> I heard about one company that is implementing mirrored disk farms, with
the disk farms at least 50 miles apart...
>
> >>> nancy.mccormick_at_sbti.com 08/24/00 04:47PM >>>
> So what are some solutions for when the disk/database fails? I understand
> Replication and have been introduced to Oracle's Standby Database. And I
am
> sure there are other possibilities. I would be interested in hearing what
> have some of you implemented.
>
> Nancy
>
> -----Original Message-----
> Carmichael
> Sent: Thursday, August 24, 2000 9:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
> well, that's not really a hot standby database, as defined by Oracle. If
the
> disks fail, you are still SOL.
>
>
> >From: "Tim Sawmiller" <sawmillert_at_state.mi.us>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: best hot standby solution
> >Date: Thu, 24 Aug 2000 04:47:31 -0800
> >
> >How about a nice EMC disk farm, and two servers, each with an instance
> >running against your database (Parallel Server). Using OAS as the front
> >end (preferably on a smaller third server), when one server fails, OAS
can
> >switch the connections over to ther other server.
> >
> > >>> rahul_at_ratelindo.co.id 08/24/00 04:06AM >>>
> >List,
> >
> >which is the best "HOT standby" solution for an 24x7 database ?,
> >able to "switch" to the standby DB, in shortest possible time.
> >
> >TIA
> >
> >Rahul
> >
> >--
> >Author: Rahul
> > INET: rahul_at_ratelindo.co.id
> >
> >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).
> >
> >--
> >Author: Tim Sawmiller
> > INET: sawmillert_at_state.mi.us
> >
> >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).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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).
>
> --
> Author: Nancy McCormick
> INET: nancy.mccormick_at_sbti.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).
>
> --
> Author: Tim Sawmiller
> INET: sawmillert_at_state.mi.us
>
> 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
Received on Thu Aug 24 2000 - 17:00:36 CDT

Original text of this message

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