From oracle-l-bounce@freelists.org Thu Jul 7 09:47:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j67ElJjH006476 for ; Thu, 7 Jul 2005 09:47:19 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j67El6IP006437 for ; Thu, 7 Jul 2005 09:47:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A0DFC1C9E75; Thu, 7 Jul 2005 09:21:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22118-05; Thu, 7 Jul 2005 09:21:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F35F1C9BD8; Thu, 7 Jul 2005 09:21:36 -0500 (EST) x-mimeole: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: High Availability -- True 7x24x365 Date: Thu, 7 Jul 2005 10:18:15 -0400 Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C001F6768F@usa0300ms03.na.xerox.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: High Availability -- True 7x24x365 Thread-Index: AcWC/W5KAMrvEyn4Rx2u1iGVieeHWwAAHk0A From: "Hameed, Amir" To: "ORACLE-L" X-OriginalArrivalTime: 07 Jul 2005 14:18:17.0226 (UTC) FILETIME=[B81ED6A0:01C582FE] X-archive-position: 22174 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Amir.Hameed@xerox.com Precedence: normal Reply-To: Amir.Hameed@xerox.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 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@freelists.org [mailto:oracle-l-bounce@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. ----- Original Message ----- From: "Goulet, Dick" To: ; "Oracle-l" Sent: Thursday, July 07, 2005 2:48 PM Subject: RE: High Availability -- True 7x24x365 > 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@freelists.org > [mailto:oracle-l-bounce@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@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-l