Integrating Oracle and Data Protector

Restoring an Oracle Database

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.

76

Chapter 1