Restoring hot backup from machine 1 to machine 2
I have an Oracle hot backup from machine 1, and I want to restore it on machine 2. Can you give me the step-by-step procedure to do this job? The OS is Unix Solaris.
On your new server, install Oracle. If possible, re-create the same directory structure for your files. Then place those files in the correct location on the new server. At this point, recovery is no different than if you recovered on the original server.
If you need to use a new directory structure, you will first have to modify the parameter file to point to the new control file locations. Then STARTUP MOUNT the database. Issue ALTER DATABASE RENAME commands to update the control files with the new locations of your database datafiles and online redo logs. At this point, recovery is no different than if you recovered on the original server.
This was first published in September 2006