Restore an Oracle Instance using Image Level

Before you Begin

Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore an Oracle Instance:

1. Shut down the Oracle database:

   SQL> shutdown immediate

2. Perform a Browse and Restore procedure to restore all volumes of the Oracle Instance.

3. In the restored Oracle archive log directory, locate the following two files:
   • CTRLFILELOCATIONS ----> This file contains the location of the all the control files.
   • CTRLFILEBACKUP.CTL ----> This is the backup control file.
4. Use CTRLFILEBACKUP.CTL to overwrite all the control files mentioned in the CTRLFILELOCATIONS.

   Example for Windows; if your restored Oracle archive log volume is g:, then type the following commands:

   • copy g:\oracleDB\CtrlFileBackup.ctl c:\oracledata\control01.ctl
   • copy g:\oracleDB\CtrlFileBackup.ctl c:\oracledata\control02.ctl
   • copy g:\oracleDB\CtrlFileBackup.ctl c:\oracledata\control03.ctl
5. Log in to SQL with sysdba privileges, and type the following command:

   startup mount;

6. After the database is mounted, type the following command to recover the database:

   recover database until cancel using backup controlfile;

7. After the prompt, type auto or enter the archive log directory location to apply the archived logs.
8. Type the following command:

   alter database open resetlogs;

9. Now the database should be in open mode; the production server is now fully restored and ready for use.