| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: High Availability - 99.999%
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> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>A small correction...</FONT></DIV>
<DIV> </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> </DIV>
<DIV><FONT face=3DArial size=3D2>This 99.999 % is populary known as 5 =
NINES 5=20
MINUTES</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>i.e 99.999 availablity with 5 minute=20
downtime..</FONT></DIV><DIV> </DIV>
<DIV> </DIV>
<DIV> </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> </DIV>
quickly.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV> <DIV><FONT face=3DCourier size=3D2>Eric Lansu</FONT> </DIV> <BLOCKQUOTE=20
<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 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>
<DIV><FONT face=3DArial=20
size=3D2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
Received on Mon Sep 04 2000 - 08:22:49 CDT
 |
 |