Ask the Expert

Testing offline backup by restoring files to remote site

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?

    Requires Free Membership to View

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

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: