How To Restore Controlfile From A Backupset Without A Catalog Or Autobackup (Doc ID 403883.1)

Last updated on FEBRUARY 24, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Sep-2014***

Goal


Explain the process to restore a controlfile in a RMAN backupset (not autobackup)
when there is no catalog present. This is an example of a controlfile in a
backupset:

RMAN> backup datafile 1 include current controlfile;

Starting backup at 00-JAN-00
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\ORCL92\SYSTEM01.DBF
including current controlfile in backupset
channel ORA_DISK_1: starting piece 1 at 00-JAN-00
channel ORA_DISK_1: finished piece 1 at 00-JAN-00
piece handle=C:\BACKUP\05I5919N_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 00-JAN-00

Solution

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 hundreds of Community platforms