Perth, Australia
+ (61) 417713124

Performing a 32 bit to 64 bit migration using the Transportable Database RMAN feature

  • Posted by Gavin Soorma
  • On October 17, 2012
This note describes the procedure used to perform a 32 bit to 64 bit conversion of an database on the Linux platform.

The RMAN CONVERT DATABASE command is used to automate the movement of an entire database from one platform (the source platform) to another (the destination platform). 

This is provided that the source and destination platforms are of the same endian format.

For example between Linux X86 32 bit and Linux X86 64 bit.

Note the following:

•	Certain types of blocks, such as blocks in undo segments, need to be reformatted to ensure compatibility with the destination platform.

•	Redo log files and control files from the source database are not transported. New control files and redo log files are created for the new database during the transport process, and an OPEN RESETLOGS is performed once the new database is created

•	BFILEs are not transported. RMAN provides a list of objects using the BFILE datatype in the output for the CONVERT DATABASE command, but users must copy the BFILEs themselves and fix their locations on the destination database.

•	Tempfiles belonging to locally managed temporary tablespaces are not transported. The temporary tablespace will be re-created on the target platform when the transport script is run.

•	External tables and directories are not transported

•	Password files are not transported. If a password file was used with the source database, the output of CONVERT DATABASE includes a list of all usernames and their associated privileges. Create a new password file on the destination database using this information

Download the note ....


Leave Reply

Your email address will not be published. Required fields are marked *