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.
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';
switch datafile all;
switch tempfile all;
Step 5: Open the database
alter database open resetlogs;