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
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;
 

Advertisements

2 thoughts on “Register rman backup in control file with catalog command

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s