Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: