Problem solve Get help with specific problems with your technologies, process and projects.

Testing offline backup by restoring files to remote site

These are the basic steps to restore a cold backup on a new server.

I have been taking a weekly offline backup. The operating system is HP-UX11i with an Oracle 9i database. I have...

an another development environment with the same operating system and an Oracle 9i database on a remote site, and I have already installed different instances on that site.

Now I want to test the offline backup by restoring all the data files, control files and the init.ora file, retaining all instances on that remote site. What are the steps to achieve this?

The basic steps to restore your cold backup on this server are as follows:

  1. Copy the cold backup to the new server. It is desirable to use the same directory structure, if possible. Make sure you copy your initialization and password files too.
  2. Hopefully, you've got a copy of your control file, dumped to a trace file. This lists all of your database's data files. This is information that you'll need, as you'll see below.
  3. Modify the initialization file to point to the new location of your control files.
  5. For each data file and online redo log file, perform the following:
       ALTER DATABASE RENAME FILE '/old_directory/filename'
       TO '/new_directory/filename';

    If the directory structure does not change, then you can skip this step. This is where a copy of your control file dumped to trace can really help. It will list all of the file names, complete with their old directory structure.


Your database should now be running on the new server.

This was last published in October 2004

Dig Deeper on Oracle database backup and recovery

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.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.