Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: non-rolling upgrades

Re: non-rolling upgrades

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Thu, 23 Jun 2005 09:51:22 -0700 (PDT)
Message-ID: <Pine.LNX.4.60.0506230948110.771@cpq7598>


The standard way to upgrade a system with a standby is to upgrade the primary, keep the standby rolling forward until it encounters the first log from the new Oracle version, then restart the standby on the new ORACLE_HOME, change any init parameters (like COMPATIBLE), and then just let it continue rolling forward.

The standby doesn't save you downtime for the upgrade, but it definitely doesn't have to be rebuilt.

--
Jeremiah Wilton
ORA-600 Consulting
Emergencies - Seminars - Hiring
http://www.ora-600.net

On Thu, 23 Jun 2005, Paul Baumgartel wrote:


> Can you clarify this? Are you talking about a logical standby or
> physical standby?
>
> On 6/22/05, Mladen Gogala <mgogala_at_allegientsystems.com> wrote:
>> The best you
>> can do is to switch over
>> to standby, upgrade the primary database, then upgrade the standby and
>> rebuild the standby.
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 23 2005 - 12:56:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US