Tag Archives: catalog start with

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;