Register rman backup in control file with catalog command

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

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';
restore database;
switch datafile all;
switch tempfile all;
recover database;

Step 5: Open the database
alter database open resetlogs;

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.