Q

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.
  4. STARTUP MOUNT
  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.

  6. ALTER DATABASE OPEN;

Your database should now be running on the new server.

This was first published in October 2004
This Content Component encountered an error

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