Re: non-rolling upgrades

  • From: Jeremiah Wilton <jeremiah@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 23 Jun 2005 09:51:22 -0700 (PDT)

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@xxxxxxxxxxxxxxxxxxxx> wrote:
The best you
can do is to switch over
to standby, upgrade the primary database, then upgrade the standby and
rebuild the standby.
--
//www.freelists.org/webpage/oracle-l

Other related posts: