RE: ZERO Database Downtime???
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>, <davidsharples@xxxxxxxxx>
- Date: Wed, 29 Mar 2006 12:52:58 -0500
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:
