RMAN convert command to migrate Oracle from Big Endian to Little Endian
How do you migrate a 2TB Oracle 9i from HP-UX (Big Endian) to 10g on Linux (Little Endian)? Can I use RMAN CONVERT DATAFILE / TABLESPACE ? My downtime window is short so I need the fastest way to to do this migration. Can you give me some tips or guide me through the best way?
The CONVERT command in RMAN is useful if you will be using Transportable Tablespaces for moving the datafiles. First, on the Linux system, you'll need to create a new database. Then on the HP-UX system, use the RMAN CONVERT command to convert the endianness, similar to the following:
RMAN TARGET /
CONVERT TABLESPACE ts1,ts2 TO PLATFORM 'Linux IA (32-bit)' FORMAT '/tempdir/%U';
Once you have converted the datafiles, FTP them to the destination server (in BINARY mode) and use TTS to plug them in.
Oracle has a document with more details on how to use TTS for this operation. Keep in mind that TTS will not transfer non-segment objects like views, procedures, etc. You will have to recreate those in the destination database.
This was first published in July 2009