Q

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?

This Content Component encountered an error
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close