Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: High Availability -- True 7x24x365
It becomes even more complex when you are using an application like Oracle's E-business suite. During the upgrades/patching, the application is unavailable to the end users and it is quite difficult to engineer a solution where all transactions could be routed to another database and then somehow captured and reapplied to the 11i database after the upgrade. We have tried it once in the past but because of the number of tables involved (thousands) and the complexity of oracle apps, we were only able to provide offline operations to just one part of the business. So, if you are using Oracle apps and consider downtime as either scheduled or unscheduled then it will be extremely difficult to implement 99.9999% availability. We have explored this opportunity extensively and discovered that even Oracle Corporation internally shuts down the apps during upgrades. Go figure ..
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Põder
Sent: Thursday, July 07, 2005 10:02 AM
To: ORACLE-L
Subject: Re: High Availability -- True 7x24x365
Hi,
Well, if we speak about true high availability (close to 100% stuff), everything from power supply up to user itself has to be involved. For example TP monitors multiplexing all transactions to different databases, or even the client program sending transactions to multiple locations and not returning before all database have committed the transaction. But this has do be considered from IS strategic planning stage and it is very expensive - usually the companies with definite need for 99.99999% availability will reduce their requirement to 99.5% or even lower, after seeing the cost and effort required for having a true high-availability system.
Tanel.
> Pete,
>
> We're close to your wants, mainly by accident. We purchased
> reliable servers (HP 9000) and good disk subsystems (EMC Symmetric), a
> good battery backup UPS with a fast start generator. With that we've
> got 90% uptime with no unscheduled down time. Scheduled downtime is
> still a need. We're looking into RAC with 10g to give us the remaining
> 10% but I'm skeptical.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Barnett
> Sent: Thursday, July 07, 2005 9:35 AM
> To: Oracle-l
> Subject: High Availability -- True 7x24x365
>
> We have finally moved into the modern digital world.
> Outages of our company web site are being noticed by
> our customers which is causing management to ask about
> maintaining 7x24x365 up time.
>
> There are several ideas being circulated but I was
> wondering how others are doing it?
>
> The requirement is true 7x24x365. Patches, upgrades,
> maintenance need to be transparent to the users of our
> web sites.
>
>
>
>
>
> Pete Barnett
> Lead Database Administrator
> The Regence Group
> pnbarne_at_regence.com
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 07 2005 - 09:47:19 CDT