Rolling Upgrade of Oracle 10gR2 RAC with Physical Standby (DG)

Advertisement
Hi DBAs,
I want to do a rolling upgrade of Oracle 10.2.0.3 (2 node RAC+ASM) with Physical Standy Dataguard to Oracle 10.2.0.4 also applying CPU (April2009).
Please suggest the best way to perform this upgrade and patching with no downtime.
Thanks
-Samar-
Advertisement

Replay

Unfortunately rolling upgrade is only possible with a logical standby in place:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/upgrades.htm#CHDBJAGG
That doesn't help you at this time, but 11g has a way to do it with a physical standby. Even here you need an intermediate logical standby:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/rollup.htm#CHDHCBGA
Werner