Q

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 first published in June 2007

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

1 comment

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close