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:
-
Shut down the Oracle database:
SQL> shutdown immediate
-
Perform a Browse and Restore procedure
to restore all volumes of the Oracle Instance.
- 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.
- 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
- Log in to SQL with sysdba privileges, and
type the following command:
startup mount;
- After the database is mounted, type the following command to recover the
database:
recover database until cancel using
backup controlfile;
- After the prompt, type auto or enter the
archive log directory location to apply the archived logs.
- Type the following command:
alter database open resetlogs;
- 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:
-
Perform a Browse and Restore procedure
to restore all volumes of the Oracle Instance.
-
After the restore job has completed, shut down the Oracle database:
- 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.
- 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.
- 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
- Log in to SQL with sysdba privileges,
and type the following command:
startup mount;
- After the database is mounted, type the following command to recover the
database:
recover database until cancel using backup
controlfile;
- After the prompt, type the following:
auto
- Type the following command:
alter database open resetlogs;
- Now the database should be in open mode; the production server is now fully restored and ready for use.
Back To Top