Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: