DB upgrade from 11.2.0.3 to 11.2.0.4 RAC in New DB Servers
Hi,
Our Critical Database is implemented on Oracle 11gR2 11.2.0.3 Single Instance DB with Oracle Data Guard Standby DB.
We want to upgrade to Oracle 11gR2 RAC 11.2.0.4 in a New 2 Node Envcan't upgrade now to !2c as application is not supported)
I have thought of 2 options to upgrade:
Option 1
- Install 11.2.0.4 RAC in 2 New DB Servers
- Install 11.2.0.3 in one of the DB Server (Node 1)
- Backup and Restore DB from Prod to DB Server Node 1 (recovery not required as we will use Offline Backup)
- Start DB in 11.2.0.3 Env
- Upgrade to 11.2.0.4 using DBUA in 11.2.0.4 env
Option 2
- Install 11.2.0.4 RAC in 2 New DB Servers
- Backup and Restore DB from Prod to DB Server Node 1 using RMAN