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.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.