Applying Oracle RAC Patche on Production Env.
One of our customers has implemented Production System on a Two Node Oracle 10g R2 RAC (10.2.0.3.0) with ASM and DR Site with Oracle Dataguard on ASM (Single Instance).
Occasionally they get some issues and it appears these issues are fixed in 10.2.0.4.0 or in 10.2.0.5.0.
Now they want me to apply the Patchset 4 (10.2.0.5.0) on the Production env. I am skeptical about applying patchset in Production env without first applying on Test env as I feel the risks are higher.
They don’t have Oracle RAC on Test env and there is no way to test the Patchset.
Please advice what would be the best course of action in such cases. This is issue with few more customers as they have Oracle RAC on Production but have Single Instance Test env.