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.

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top