Problem solve Get help with specific problems with your technologies, process and projects.

Migrate Oracle 10g database from Linux to AIX

I would like to migrate Oracle 10g on a Linux server (RHEL4) to AIX 5L. I have alreay installed Oracle 10g. What is the best approach?

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"?
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 last published in June 2007

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

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

Please create a username to comment.


Can't we use Transportable Tablespace to Migrate the 10g database from Linux to IBM AIX platform.

Please kindly advice for the request.

Hussain konidela.