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: High Availability - 99.999%

Re: High Availability - 99.999%

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Fri, 1 Sep 2000 11:05:55 +0200
Message-Id: <10606.116053@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0DF5_01C01404.9959FC90 Content-Type: text/plain;

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

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=20

  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?   =20
  Thanks,
  Nancy
  =20

------=_NextPart_000_0DF5_01C01404.9959FC90 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 content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>99.999% availability means 8.544 =
hours, say 8 1/2=20
hours of downtime a year! A machine with more than 1 processor, = power-supply,=20
Raid-x diskmirroring, seperate network connections etc. Could do the=20 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 = have a=20
DBA stand by around the clock, for a down at 23:00, and up at 7:00 = consumes all=20
your 'accepted downtime'</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Never upgrade the Oracle version, for =
this takes=20
too long</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>etc. etc.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>It should be possible to provide this =

availability without OPS. But if it's really such a big issue, why not = use it?=20
We work&nbsp;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 etc.=20
while the other one still works.&nbsp;Switch the servers, and upgrade = the second=20
one. Syncronize servers&nbsp;when&nbsp;all&nbsp;the time staying in the = air.=20
Machines are in different locations, so trouble from the outside has no = effect.=20
(Some years ago an airplane fell out of the sky near&nbsp;one of the=20 locations...)</FONT></DIV>
<DIV>&nbsp;</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 use=20
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=20 quickly.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>Eric Lansu</FONT>&nbsp;</DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-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 href=3D"mailto:nancy.mccormick_at_sbti.com" = title=3Dnancy.mccormick_at_sbti.com>Nancy=20   McCormick</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

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

  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&nbsp;the possible&nbsp;pieces going into providing 99.999%=20   availability&nbsp;in an Oracle/Sun environment.&nbsp; 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.&nbsp;&nbsp;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>&nbsp;</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 - 04:05:55 CDT

Original text of this message

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