RE: High Availability

From: Nancy McCormick <nancy.mccormick_at_sbti.com>
Date: Fri, 1 Sep 2000 07:04:36 -0500
Message-Id: <10606.116063@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_001E_01C013E2.E3D68F80 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

It's not that I don't want to use OPS. I just wanted to understand other options. I do like the idea of having the ability to do maintenance, etc on 1 server while the other continues to work. Thanks for your reply.

Nancy
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Eric Lansu Sent: Friday, September 01, 2000 4:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: High Availability - 99.999%

99.999% availability means 8.544 hours, say 8 1/2 hours of downtime a year! A machine with more than 1 processor, power-supply, Raid-x diskmirroring, seperate network connections etc. Could do the job. Don't let any dba's, nor developers work on it - that's the most important thing -, and correct a problem immediately. So have a DBA stand by around the clock, for a down at 23:00, and up at 7:00 consumes all your 'accepted downtime'
Never upgrade the Oracle version, for this takes too long etc. etc.

It should be possible to provide this availability without OPS. But if it's really such a big issue, why not use it? We work with national e-commerce, and most people sleep between say 3:00 and 6:00. Still we use OPS. I can bring one server down to upgrade, correct etc. while the other one still works. Switch the servers, and upgrade the second one. Syncronize servers when all the time staying in the air. Machines are in different locations, so trouble from the outside has no effect. (Some years ago an airplane fell out of the sky near one of the locations...)

The only thing is, the sites are replicated immediate - it's not a hot standby -. So if some ..... corrupts the database, the other one is corrupted too! If this is possible, I think it's better to use a hot standby with an update delay of say 1/2 an hour. You have to switch manually, but recovery is not needed, so you can be back into business quickly.

Eric Lansu

Original Message ----- From: Nancy McCormick To: Multiple recipients of list ORACLE-L Sent: Friday, 01 September 2000 00:18 Subject: High Availability - 99.999%

I am trying to understand the possible pieces going into providing 99.999% availability in an Oracle/Sun environment. Everything I have read so far mentions using Oracle Parallel Server (OPS) to provide quick failover if a server (node) or instance fails. In your opinions are there other options besides OPS to provide this functionality?

Thanks,
Nancy

------=_NextPart_000_001E_01C013E2.E3D68F80 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D520030112-01092000><FONT face=3DArial color=3D#0000ff =

size=3D2>It's=20
not that I don't want to use OPS.  I just wanted to understand = other=20
options.  I do like the idea of having the ability to do = maintenance, etc=20
on 1 server while the other continues to work.  Thanks = for your=20
reply.  </FONT></SPAN></DIV>
<DIV><SPAN class=3D520030112-01092000><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D520030112-01092000><FONT face=3DArial color=3D#0000ff =

size=3D2>Nancy</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Eric = Lansu<BR><B>Sent:</B>=20
  Friday, September 01, 2000 4:56 AM<BR><B>To:</B> Multiple recipients = of list=20
  ORACLE-L<BR><B>Subject:</B> Re: High Availability -=20   99.999%<BR><BR></FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>99.999% availability means 8.544 =
hours, say 8=20
  1/2 hours of downtime a year! A machine with more than 1 processor,=20   power-supply, Raid-x diskmirroring, seperate network connections etc. = Could do=20
  the job.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Don't let any dba's, nor developers =
work on it=20

that's the most important thing -, and correct a problem = immediately. So=20 have a DBA stand by around the clock, for a down at 23:00, and up at = 7:00=20 consumes all your 'accepted downtime'</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Never upgrade the Oracle version, =
for this=20 takes too long</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>etc. etc.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>It should be possible to provide =
this=20 availability without OPS. But if it's really such a big issue, why not = use it?=20 We work with national e-commerce, and most people sleep between = say 3:00=20 and 6:00. Still we use OPS. I can bring one server down to upgrade, = correct=20 etc. while the other one still works. Switch the servers, and = upgrade the=20 second one. Syncronize servers when all the time = staying in the=20 air. Machines are in different locations, so trouble from the outside = has no=20 effect. (Some years ago an airplane fell out of the sky near one = of the=20 locations...)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>The only thing is, the sites are =
replicated=20 immediate - it's not a hot standby -. So if some ..... corrupts the = database,=20 the other one is corrupted too! If this is possible, I think it's = better to=20 use a hot standby with an update delay of say 1/2 an hour. You have to = switch=20 manually, but recovery is not needed, so you can be back into business =

quickly.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>Eric Lansu</FONT> </DIV>
<BLOCKQUOTE=20

  style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>

<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20

<A title=3Dnancy.mccormick_at_sbti.com=20 href=3D"mailto:nancy.mccormick_at_sbti.com">Nancy McCormick</A> </DIV> <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20

href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20

</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, 01 September = 2000=20

    00:18</DIV>
    <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> High Availability -=20     99.999%</DIV>
    <DIV><BR></DIV>
    <DIV><SPAN class=3D850445517-31082000><FONT face=3DArial size=3D2>I = am trying to=20

understand the possible pieces going into providing = 99.999%=20

availability in an Oracle/Sun environment.  Everything I = have read=20

so far mentions using Oracle Parallel Server (OPS) to provide quick = failover=20

if a server (node) or instance fails.  In your opinions = are there=20

other options besides OPS to provide this = functionality?</FONT></SPAN></DIV>

<DIV><SPAN class=3D850445517-31082000><FONT face=3DArial=20 size=3D2></FONT></SPAN><SPAN class=3D850445517-31082000><FONT = face=3DArial=20

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D850445517-31082000><FONT face=3DArial=20 size=3D2>Thanks,</FONT></SPAN></DIV> <DIV><SPAN class=3D850445517-31082000><FONT face=3DArial=20 size=3D2>Nancy</FONT></SPAN></DIV> Received on Fri Sep 01 2000 - 07:04:36 CDT

RE: High Availability - 99.999%