Restore Data - Image Level - How To

Topics | How To | Related Topics

Restore an Oracle Instance using Image Level

Restore an Oracle Instance Out-of-Place using Image Level

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.

Restore an Oracle Instance Out-of-Place 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 out-of-place:

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

2. After the restore job has completed, shut down the Oracle database:

3. Change the drive letter or mount point of the restored Oracle data file volume and Oracle archive file volume, to match the original drive letter or mount point of the Oracle volumes.
4. 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.
5. Use CTRLFILEBACKUP.CTL to overwrite all the control files mentioned in 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
6. Log in to SQL with sysdba privileges, and type the following command:

   startup mount;

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

   recover database until cancel using backup controlfile;

8. After the prompt, type the following:

   auto

9. Type the following command:

   alter database open resetlogs;

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

Back To Top