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/intro.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/upgrade.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