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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.