I'm a DBA for an insurance company in Aruba. I would like to migrate Oracle 10g on a Linux server (RHEL4) to a IBM P Series running AIX 5L. I have alreay installed Oracle 10g release 2 on the AIX 5L operating system. What is the best approach for me to migrate my database? Could I just restore a recent backup (Linux platform datafiles) on AIX to "re-create the database"?

    Requires Free Membership to View

One of the best methods when moving from one OS platform to another is to use Oracle's export and import utilities. Since you are on 10g, you can also use Data Pump (expdp and impdp). Perform a FULL export of your database on Linux and then FTP the file in binary mode to your AIX server. From there, perform a full import. This is similar to how one might upgrade their database, but without the actual change in versions.

This was first published in June 2007

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: