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:
- 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.
- 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.
- Modify the initialization file to point to the new location of your control files.
- STARTUP MOUNT
- 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.
- ALTER DATABASE OPEN;
Your database should now be running on the new server.
This was first published in October 2004