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: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Mon, 4 Sep 2000 14:22:49 +0100
Message-Id: <10609.116138@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_010E_01C0167B.9A70DC10 Content-Type: text/plain;

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

Eric !

A small correction...

99.999 % availabily menas only 5 minutes downtime per hour. NOT 8 1/2 = hours downtime per year.
If you have 8.5 hrs downtime/year it is 99.99%

This 99.999 % is populary known as 5 NINES 5 MINUTES

i.e 99.999 availablity with 5 minute downtime..

Regards,
K Gopalakrishnan
Bangalore, INDIA

  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.
  =20
  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_010E_01C0167B.9A70DC10 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.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Eric !</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>A small correction...</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>99.999 % availabily menas only 5 =
minutes downtime=20
per hour. NOT 8 1/2 hours downtime per year.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>If you have 8.5 hrs downtime/year it is =

99.99%</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>This 99.999 % is populary known as 5 =
NINES 5=20
MINUTES</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>i.e 99.999 availablity with 5 minute=20

downtime..</FONT></DIV>

<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>K Gopalakrishnan</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bangalore, INDIA</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&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:eric.lansu_at_quicknet.nl" = title=3Deric.lansu_at_quicknet.nl>Eric=20
  Lansu</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, September 01, = 2000 10:56=20
  AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: High Availability = -=20
  99.999%</DIV>
  <DIV><BR></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

  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"=20     title=3Dnancy.mccormick_at_sbti.com>Nancy McCormick</A> </DIV>     <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20     href=3D"mailto:ORACLE-L_at_fatcity.com" = title=3DORACLE-L_at_fatcity.com>Multiple=20

    recipients of list ORACLE-L</A> </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&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>
    <DIV><FONT face=3DArial=20
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> Received on Mon Sep 04 2000 - 08:22:49 CDT

Original text of this message

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