RE: ZERO Database Downtime???

But see, all of this is *not* RAC! And the RAC sales pitch *always* sells rolling upgrades and "your database is never down".  

Lies and obfuscations!  

From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Wednesday, March 29, 2006 12:20 PM To: davidsharples_at_gmail.com
Cc: Mercadante, Thomas F (LABOR); MFontana_at_verio.net; oracle-l_at_freelists.org
Subject: Re: ZERO Database Downtime???  

On 3/29/06, David Sharples <davidsharples_at_gmail.com> wrote:

        I believe it has something to do with dataguard, i.e. failover to standby server, then upgrade your primary and then switch back          

        or something like that

Oracle documentation may not help you here.

From the "Oracle Databas Upgrade Guide", the "Rolling Upgrades" section found here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14238/intr o.htm#sthref45

     Using SQL Apply and logical standby databases, you     can upgrade Oracle database software and patch sets      with little or no database downtime

From the 'Upgrading to 10g" chapter of the same guide, found here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14238/upgr ade.htm#CACHBEAC

    Starting with Oracle Database 10g release 1 (10.1.0.3), you can     use SQL Apply on a logical standby database to perform a rolling     upgrade of the Oracle Database 10g software. During a rolling upgrade,

    you can run different releases of the Oracle database on the primary     and logical standby databases while you upgrade them, one at a time,

    incurring minimal downtime on the primary database.

You know of course, the only sure way to know if it can be done in the circumstances you require is to try it. :)

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 29 2006 - 11:52:58 CST