How to migrate from 32 bit to 64 bit using RMAN?

This procedure can be used for single instance or RAC (9i to 11g):

In the 32 bit source server :

Start making a full backup of the database including all archivelogs:

RMAN> run  {  

allocate channel c1 type disk;  

allocate channel c2 type disk;  

backup database plus archivelog;  

backup current controlfile;  }


In the target 64 bit server:
1) Copy backup files from source server
2) Create the pfile or copy the pfile fromsourceserver
3) Startup nomount the new instance.
4) Connect to rman and set the dbid:

$ rman target / nocatalog RMAN> set dbid=<dbid from the 32 server>;

5) Restore the controlfile:

RMAN> restore controlfile from '/disk1/backup_32/backup_piece_name';

RMAN> alter database mount;

RMAN> restore database;

6) Identify the archivelog till you want to do the recovery and check if you have all the backups you need to do it and run:

RMAN> run {

set until sequence xxxx;

recover database;

}

RMAN> exit

7) Now Migrating to 64 bit:

SQL> recover database until cancel using backup controlfile;

cancel

SQL> alter database open resetlogs migrate;

SQL> @$ORACLE_HOME/rdbms/admin/utlirp.sql

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

SQL> shutdown immediate;

SQL> startup

Note: Also please take a look in other methods in the following Metalink Note:

  • Migration of Oracle Instances Across OS Platforms – Doc ID: Note:733205.1

Cheers,

Francisco Munoz Alvarez

Advertisements

Oracle ACE Director and President of LAOUC, NZOUG and CLOUG. Organizer of LA and APAC OTN Tours,

Posted in General, Interview Tips, Migrations, Oracle FAQ, Questions, Tutorials, Upgrade/Migration
6 comments on “How to migrate from 32 bit to 64 bit using RMAN?
  1. mksingh017 says:

    Thanks sir its very helpfull.

  2. Oracle NZ – Francisco Munoz Alvarez » How to migrate from 32 bit to 64 bit using RMAN?…

    Need to Migrate from 32 to 64 bits using Rman? Let me try to help you……

  3. sandeep says:

    Your blog helped me in migration of a 2-node 9i RAC from 64-bit to 32-bit..although with some changes
    But thanks, your article was the base for me.

  4. admin says:

    Dear mksingh017 and Sandeep,

    You are Welcome, I’m happy to help some fellow DBAs and to see that my modest posts are helping others.

    Dear Sandeep,

    Please feel free to post the modifications and your experience, to this way help others who need to go thru the same process.

    Cheers,

    Francisco Munoz Alvarez

  5. Shubhaditya Mukherjee says:

    hi Francisco Sir,
    Please tell me, whether the backup taken in step 1 has to be cold backup or online backup, as we have a situation with production database.

    Regards,
    Shubhaditya

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: