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@xxxxxxxxx] 
Sent: Wednesday, March 29, 2006 12:20 PM
To: davidsharples@xxxxxxxxx
Cc: Mercadante, Thomas F (LABOR); MFontana@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: ZERO Database Downtime???

 

On 3/29/06, David Sharples <davidsharples@xxxxxxxxx> 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

Other related posts: