My Oracle Support Banner

RMAN - How to restore the controlfile using RMAN (Doc ID 580414.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version 9.2.0.1 and later
Oracle Database - Personal Edition - Version 9.2.0.1 and later
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Goal

There are many ways to restore the controlfile for recovery using RMAN. This note provides several examples of how to get the controlfile back quickly so the restore of the database can be started asap.

Note: If you do not specify where to restore the controlfile to the parameter control_files is used with the respective names and locations listed in the parameter file (init.ora or spfile).

Configuring the Control File Autobackup Format

By default, the format of the autobackup file for all configured devices is the substitution variable %F in the FORMAT clause. This variable format translates into c-IIIIIIIIII-YYYYMMDD-QQ, with the placeholders defined as follows:

 IIIIIIIIII stands for the DBID.

 YYYYMMDD is a time stamp of the day the backup is generated.

 QQ is the hex sequence that starts with 00 and has a maximum of FF.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.