Rolling Upgrade of Oracle 10gR2 RAC with Physical Standby (DG)
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.
Unfortunately rolling upgrade is only possible with a logical standby in place:
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: