How to Register RMAN Backup in Control File

Register RMAN backup manually in control file with catalog command

Steps for catalog RMAN backup with control file for recovery purpose

I have old backup but it is not available with current control file. For restore purpose, I need to first register the backup first with Control file with CATALOG command. Then we start the restore command.

Suppose I lost completed database and have control file.
Then I need to registry/catalog the rman backup with current control file.

Step 1 : Having backup at d: drive. Suppose at d:\rman location.

Step 2 : Connect with RMAN database to target
rman target sys

Step 3: Register or catalog backup location with control file
CATALOG START WITH 'D:\rman' NOPROMPT;

Step 4: After finish the sync, We can start the restore and recover process.

RUN {
set newname for datafile 1 to 'E:\ORACLE11g\ORADATA\orcl\SYSTEM01.DBF';
set newname for datafile 2 to 'E:\ORACLE11g\ORADATA\orcl\SYSAUX01.DBF';
set newname for datafile 3 to 'E:\ORACLE11g\ORADATA\orcl\UNDOTBS01.DBF';
set newname for datafile 4 to 'E:\oracle11g\ORADATA\orcl\USERS01.DBF';
set newname for tempfile 1 to 'E:\oracle11g\ORADATA\orcl\TEMP01.DBF';
restore database;
switch datafile all;
switch tempfile all;
recover database;
}

Step 5: Open the database
alter database open resetlogs;

Leave a Reply