Re: OPS in NT Environment

From: Richard Eastham <eastham_at_flash.net>
Date: Wed, 20 Sep 2000 22:33:45 -0500
Message-Id: <10625.117528@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_00A4_01C02352.D60DE860 Content-Type: text/plain;

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

Sanjeev,

I have included a matrix that gives some basics as to what is required = to achieve a given level of availability. In order to have 99.99% = availability you will need more than 1 site/machine/database. There are = several ways to get there but there is more than a few requirements to = achieve this goal. OPS only helps with a failure of a server component. = If any kind of corruption occurs to the database, a recovery will still = cause an outage. Given that you have only .88 hours in the entire year = for system unavailability based upon the percentage you are talking = about, your backup/recovery solution had better be pretty spectacular. = You will still need a failover system in order to insure that the = maximum outage is limited and for complete redundancy you need to have = the failover system in another data center separated geographically from = your other server.

System Availability Matrix

      Required Availability
     Unexpected Outage hours/year
     Minimum Infrastructure Requirements (inclusive as required =

availability increases)

=20

      99.00%
     87.6
     Sound security practices, Local system and hardware redundancy =

(redundant disks, multiple network connections, redundant controllers, = etc.), Well-defined upgrade plan, Hot backups, Sound = backup/restore/recovery plan.

=20

      99.25%
     65.7
     Fast backup-restore procedure (less than 4 hours), Monitoring =

facility (good detection).=20

=20

      99.50%
     43.8
     Fast backup-restore procedure (less than 2 hours), Automation of =

backup-restore-recovery operations, Application fail over, Redundant = copies onsite (triple mirroring), Archives online.

=20

      99.75%
     21.9
     Fail over system, Object level recovery, Disaster recovery site =

(less than 30 minutes).

=20

      99.90%
     8.76
     One or more disaster recovery sites (less than 10 minutes), remote =

redundancy.

=20

      99.99%
     0.88
     Full automation of detection and repair.
    =20
      99.999%
     0.08
     Three-tier with full replication of application, system and =

database, redundant pairs throughout the entire application workflow, = rolling upgrades, secure system where user errors are eliminated.

=20

P.S. The matrix originally comes from a white paper available on = metalink on high availability.

Original Message -----=20 From: "Sanjeev Singh" <ssingh_at_symyx.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 20, 2000 2:01 PM Subject: OPS in NT Environment

> Hi Folks,

>=20
> Can anyone send me their hardware configuration =
running
> 8.1.6 with OPS option on Win2k. Is OPS is the answer for 99.99% =
database
> availability and load balancing?=20
> Any suggestions will be greatly appreciated.
> =20
> Thanks,
> Sanjeev

>=20
>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Sanjeev Singh
> INET: ssingh_at_symyx.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

------=_NextPart_000_00A4_01C02352.D60DE860 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.4207.2601" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=3D2>Sanjeev,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I have included a matrix that gives some basics as =

to what is=20
required to achieve a given level of availability.  In order to = have 99.99%=20
availability you will need more than 1 site/machine/database.  = There are=20
several ways to get there but there is more than a few requirements to = achieve=20
this goal.  OPS only helps with a failure of a server component. If = any=20
kind of corruption occurs to the database, a recovery will still = cause an=20
outage.  Given that you have only .88 hours in the entire year for = system=20
unavailability based upon the percentage you are talking about, your=20 backup/recovery solution had better be pretty spectacular. You will = still need a=20
failover system in order to insure that the maximum outage is limited = and for=20
complete redundancy you need to have the failover system in another = data=20
center separated geographically from your other server.</FONT></DIV>

<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV>
<DIR>
<DIR><I><FONT face=3DGaramond size=3D2>
<P align=3Djustify>System Availability Matrix</P></DIR></DIR></I></FONT>
<P align=3Dright>
<TABLE borderColor=3D#000000 cellSpacing=3D2 cellPadding=3D7 width=3D595 =

border=3D1>
<TBODY>
<TR>

    <TD vAlign=3Dtop width=3D"18%"><B><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Required Availability</B></FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><B><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Unexpected Outage =

hours/year</B></FONT></P></TD>

<TD vAlign=3Dtop width=3D"61%"><B><FONT face=3DGaramond size=3D3> <P align=3Djustify>Minimum Infrastructure Requirements (inclusive = as=20

required availability increases)</B></FONT></P></TD></TR> <TR>

    <TD vAlign=3Dtop width=3D"18%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>99.00%</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>87.6</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"61%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Sound security practices, Local system and =
hardware=20
      redundancy (redundant disks, multiple network connections, =
redundant=20
      controllers, etc.), Well-defined upgrade plan, Hot backups, Sound=20
      backup/restore/recovery plan.</FONT></P></TD></TR>

<TR>

    <TD vAlign=3Dtop width=3D"18%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>99.25%</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>65.7</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"61%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Fast backup-restore procedure (less than 4 =
hours),=20
      Monitoring facility (good detection). </FONT></P></TD></TR>

<TR>

    <TD vAlign=3Dtop width=3D"18%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>99.50%</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>43.8</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"61%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Fast backup-restore procedure (less than 2 =
hours),=20
      Automation of backup-restore-recovery operations, Application fail =
over,=20
      Redundant copies onsite (triple mirroring), Archives=20

online.</FONT></P></TD></TR>
<TR>

    <TD vAlign=3Dtop width=3D"18%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>99.75%</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>21.9</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"61%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Fail over system, Object level recovery, =
Disaster=20
      recovery site (less than 30 minutes).</FONT></P></TD></TR>

<TR>

    <TD vAlign=3Dtop width=3D"18%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>99.90%</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>8.76</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"61%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>One or more disaster recovery sites (less than =
10=20
      minutes), remote redundancy.</FONT></P></TD></TR>

<TR>

    <TD vAlign=3Dtop width=3D"18%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>99.99%</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>0.88</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"61%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Full automation of detection and =

repair.</FONT></P></TD></TR>
<TR>

    <TD vAlign=3Dtop width=3D"18%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>99.999%</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"21%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>0.08</FONT></P></TD>
    <TD vAlign=3Dtop width=3D"61%"><FONT face=3DGaramond size=3D3>
      <P align=3Djustify>Three-tier with full replication of =
application, system=20
      and database, redundant pairs throughout the entire application =
workflow,=20
      rolling upgrades, secure system where user errors are=20
      eliminated.</FONT></P></TD></TR></TBODY></TABLE></P>
<DIR>

<DIR><FONT face=3DGaramond size=3D3>
<P align=3Djustify><FONT face=3DArial size=3D2>P.S. The matrix = originally comes from a=20
white paper available on metalink on high=20

availability.</FONT></P></DIR></DIR></FONT></DIV>
<DIV><FONT size=3D2>----- Original Message ----- </FONT>
<DIV><FONT size=3D2>From: "Sanjeev Singh" &lt;</FONT><A=20
href=3D"mailto:ssingh_at_symyx.com"><FONT =

size=3D2>ssingh_at_symyx.com</FONT></A><FONT=20 size=3D2>></FONT></DIV>
<DIV><FONT size=3D2>To: "Multiple recipients of list ORACLE-L" = <</FONT><A=20
href=3D"mailto:ORACLE-L_at_fatcity.com"><FONT=20 size=3D2>ORACLE-L_at_fatcity.com</FONT></A><FONT size=3D2>></FONT></DIV> <DIV><FONT size=3D2>Sent: Wednesday, September 20, 2000 2:01 = PM</FONT></DIV>
<DIV><FONT size=3D2>Subject: OPS in NT Environment</FONT></DIV></DIV> <DIV><FONT size=3D2><BR></FONT></DIV><FONT size=3D2>> Hi = Folks,<BR>> <BR>>=20
            &= nbsp;  =20
Can anyone send me their hardware configuration running<BR>> 8.1.6 = with OPS=20
option on Win2k. Is OPS is the answer for 99.99% database<BR>> = availability=20
and load balancing? <BR>> Any suggestions will be greatly=20 appreciated.<BR>>  <BR>> Thanks,<BR>> Sanjeev<BR>> = <BR>>=20
<BR>> -- <BR>> Please see the official ORACLE-L FAQ: </FONT><A=20 href=3D"http://www.orafaq.com"><FONT=20
size=3D2>http://www.orafaq.com</FONT></A><BR><FONT size=3D2>> -- = <BR>> Author:=20
Sanjeev Singh<BR>>   INET: </FONT><A=20

href=3D"mailto:ssingh_at_symyx.com"><FONT =
size=3D2>ssingh_at_symyx.com</FONT></A><BR><FONT=20
size=3D2>&gt; <BR>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- =

(858)=20
538-5051  FAX: (858) 538-5051<BR>> San Diego,=20 California        -- Public Internet = access /=20
Mailing Lists<BR>>=20

--------------------------------------------------------------------<BR>&=

gt; To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>> = to:=20
</FONT><A href=3D"mailto:ListGuru_at_fatcity.com"><FONT=20 size=3D2>ListGuru_at_fatcity.com</FONT></A><FONT size=3D2> (note EXACT = spelling of=20
'ListGuru') and in<BR>> the message BODY, include a line containing: = Received on Wed Sep 20 2000 - 22:33:45 CDT