Filter
Top Products
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 176
Restoring the Control File
The control file contains all the information about the database
structure. If the control file has been lost, you must restore it before you
restore any other part of the database. The database should be in the
NoMount state.
Depending on the type of the control file backup, the following types of
restore are possible when restoring the control file:
• Restoring from Data Protector managed control file backup
(CONTROLFILE FROM DP MANAGED BACKUP)
The control file was backed up automatically by ob2rman.pl at the
end of a backup session, unless the option Disable Data Protector
managed control file backup was selected.
The recovery catalog is not required for this restore option.
The control files (ctrl<DB_NAME>.dbf) are restored to:
Windows: <Data_Protector_home>\tmp
HP-UX and Solaris: /var/opt/omni/tmp
Other UNIX: /usr/opt/omni/tmp
OpenVMS: OMNI$ROOT:[TMP]
After the restore, run the following script:
run {
allocate channel 'dev0' type disk;
restore controlfile from '<TMP_FILENAME>';
release channel 'dev0';
}
Where <TMP_FILENAME> is the location to which the file was restored.
• Restoring from RMAN autobackup (CONTROLFILE FROM RMAN
AUTOBACKUP)
This type of restore is not available with Oracle 8i.
The control file was automatically backed up by RMAN and the
recovery catalog is not available.