Re: ZERO Database Downtime???

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: davidsharples@xxxxxxxxx
  • Date: Wed, 29 Mar 2006 09:20:27 -0800

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/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

Other related posts: