- Install Oracle on the new server with the same patchset level.
- Precreate a database on this new server with the same ORACLE_SID as the source database. Use the same directory structure if possible.
- Shut down your database.
- Restore your cold backup to the new server, overwriting the control files and datafiles.
- You should be able to start your database.
If the same directory structure is not possible, you'll have to modify the parameter file to point to the correct control file location after step 4. Before you can start the database, you'll also need to issue the ALTER DATABASE RENAME FILE commands for each datafile and online redo log file not in the correct location.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading