Migrating Oracle Database from 11.2.0.3 to 11.2.0.4 using RMAN (Different Server Approach) - ASM to ASM

1) copy the utlu112i.sql pre-upgrade script from 11.2.0.4 home (@$ORACLE_HOME/rdbms/admin/.)

SQL> @?/rdbms/admin/utlu112i.sql

2) Take a RMAN full backup.

rman target /

run
{
     BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT  '/u02/backup/Target_bkp_for_upgrade_%U' plus archivelog format '/u02/backup/%d_%U';
     backup current controlfile format '/u02/backup/control_ambu.ctl';
}                    

3) create pfile for migration purpose.

create pfile='/u02/backup/initambu.ora' from spfile;

** Edit the pfile as below parameters.

db_file_name_convert='DATA_C','DATA_P'
log_file_name_convert='DATA_C','DATA_P'

4) Open the database in NOMOUNT state.

startup nomount pfile='/u02/backup/initambu.ora';

rman target /

5) Restore controlfile from backup.

restore controlfile from '/u02/backup/control_ambu.ctl';

** Note the restored controlfile and edit the pfile.

output file name=+DATA_P/ambu/controlfile/current.259.862473407
output file name=+DATA_P/ambu/controlfile/current.258.862473407

6) Open the database in MOUNT state.

alter database mount;

7) Catalog RMAN backup files.

catalog start with '/u02/backup';

8) Restore and Recover 11.2.0.3 database backup to 11.2.0.4.

** check the last sequence number using ( RMAN > list backup of archivelog all;) command.

run
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
restore database until sequence 65;
recover database until sequence 65;
}

9) Open the database with RESETLOGS UPGRADE.

$ sqlplus / as sysdba
SQL> alter database open resetlogs upgrade;

10) Run the upgrade script.

SQL> SPOOL database_upgrade.log
SQL> @?/rdbms/admin/catupgrd.sql

11)  If OS platforms bits are different then you must run utlmmig.sql script.

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP UPGRADE
SQL> SPOOL migrate.log
SQL> @?/rdbms/admin/utlmmig.sql
SQL> SPOOL off

12) Open the database.

SQL> STARTUP

13) Run the Post-Upgrade script to check problems.

SQL> @?/rdbms/admin/utlu112s.sql

14) Compile invalid objects.

SQL> @?/rdbms/admin/utlrp.sql