RE: Oracle upgrade without downtime??
- From: Upendra N <nupendra@xxxxxxxxxxx>
- To: <kat.axe@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2010 15:55:43 -0400
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:
