Migration form 32 bit to 64 bit

Source Environment - (Oracle 11.2.0.3) RHEL 5, 32 bit

Destination Environment - (Oracle 11.2.0.3) RHEL 5, 64 bit


Took the RMAN Full backup of the source database on disk with archive logs.

Restored the RMAN Full backup on the destination database

Recovered the Destination Database

STARTUP NOMOUNT pfile='';
SET DBID=
restore controlfile from <autobackup piece>;
ALTER DATABASE MOUNT;
catalog backuppiece <backuppiece name> ;
RESET DATABASE TO INCARNATION 2;
Restored the RMAN Full backup on the destination database;
recovered the destination database using backup controlfile until cancel;
applied archivelogs ;

ALTER DATABASE OPEN RESETLOGS;

shutdown immediate;

startup upgrade;

@?/rdbms/admin/utlirp.sql;
shut immediate;

startup ;
@?/rdbms/admin/utlrp.sql;