Re: Oracle upgrade without downtime??

As Andreas said, it has to be logical. You can however convert the physical
standby to a logical one, run the upgrade, and then revert it back to a
physical standby.

Note 300479.1 has a link to a white paper on this ("Database Rolling
Upgrades for Physical Standby Database - using a Transient Logical Standby")
but the link isn't working right now :)

Another doc that I found quite helpful is:
www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_RollingUpgradeBestPractices.pdf
..which also isn't working right now. You can however access this one by
Googling "Database Rolling Upgrade Using Data Guard SQL Apply" and clicking
"Quick View" under the first link.



On Tue, Aug 31, 2010 at 12:55 PM, Upendra N <nupendra@xxxxxxxxxxx> wrote:

>  Thanks for your feedback.
> For the database upgrades Oracle seems to be recommending Logical standby
> database (SQL Apply).
> There are a lot of restrictions with Logical standby. Will it work with
> Physical standby?
>
> -Upendra
>
>
>
> ------------------------------
> From: kat.axe@xxxxxxxxx
> Date: Tue, 31 Aug 2010 11:51:23 -0700
> Subject: Re: Oracle upgrade without downtime??
> To: nupendra@xxxxxxxxxxx
> CC: oracle-l@xxxxxxxxxxxxx
>
>
> This link might help:
>
> http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14210/hafeatures.htm#CJAFCCFJ
>
> I haven't done a rolling upgrade with RAC so I can't comment on that route,
> but I did do one with DG and it worked great.
>
>
>
> On Tue, Aug 31, 2010 at 11:21 AM, Upendra N <nupendra@xxxxxxxxxxx> wrote:
>
>  We have a 2 node Oracle RAC on 10.2.0.3, would like to upgrade 10.2.0.4.
> Due to application SLA, I'm exploring the possibilities with no or least
> downtime for the upgrade.
>
> We'll have the 10.2.0.4 binaries installed ahead of time on both the boxes
> to reduce the window.
>
> Assuming we could potentially get another 2-node RAC cluster, what are the
> choices we could use to avoid downtime?
>
> I can think of a couple of scenarios:
> 1. Oracle Streams setup to replicate both-ways and/or similar to
> Multi-master replication
> 2. We could do something similar with Golden gate - may be more expensive..
>
> Not sure if this will work:
> 1. Data guard with switchover
>
> Any other suggestions on reducing the upgrade window are appreciated.
> Thank you
> -Upendra
>
>
>
>

Other related posts: