RE: best hot standby solution

From: Suhen Pather <PatherS5_at_telkom.co.za>
Date: Fri, 25 Aug 2000 08:28:24 +0200
Message-Id: <10599.115532@fatcity.com>

We are using HP 9000 V2500 services with lots of EMC disks and MC = ServiceGuards.
In one of our clusters of 7 servers there are 2 servers that are failover = boxes (Auxillary servers).
We have 2 instances per HP server.
There are equally sized serviers as the others in the cluster.

If one of the servers fails MC ServiceGuards Fails over the package to the = configured auxillary server.
This method is pretty efficient.
We use something called floating IP and floating hostnames so the user = does not have to reconfigure his tnsnames to connect to the database. The disks are shared between the primary server and auxillary servers. Disks are mirrored on an HP level to provide redundancy in case of disk = failure.
EMC Backups using BCV (Business Continuity Volumes). Backups from one disk = to another on the EMC level. EMC has its own caching so quick disk copy = is done.

HTH
Suhen Pather
Oracle DBA
Telkom SA

>>> Gregory_LoughMiller_at_bscc.bls.com 08/24/00 09:26PM >>>
We designed the "belt and suspenders" solution here..

2 E10K's, HUGE EMC farm(about 14TB), and using Parallel Server... One node dies, the other node will pickup. the client is configured with net8 to handle the switch....=20

That covers the 24x7 and HA...

For "disaster re-discovery", we are using the oracle version of standby database. Oh what fun to try to design a "zero data loss" environment for the DR site... The DR site is also in a separate data center about 600 = miles
away.....

Greg

-----Original Message-----
Sent: Thursday, August 24, 2000 10: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=20
>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=20
>running against your database (Parallel Server). Using OAS as the =
front=20
>end (preferably on a smaller third server), when one server fails, OAS =
can=20
>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=20
>
>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=20
>
>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=20=

--=20
Author: Rachel Carmichael
INET: carmichr_at_hotmail.com=20

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). --=20
Author: LoughMiller, Gregory
INET: Gregory_LoughMiller_at_bscc.bls.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------