How to restore database without RMAN catalog ?

[ezhilarasan_1]

Hi,

How to restore database without RMAN catalog ?

My client is doing RMAN backup without catalog. They want to test restore and recover the database in another machine, also want to test restore in the same m/c.

I am wondering How to restore without RMAN catalog !!
Assume that backup is taken in disk in some directory.

Experts, can someone help me.

Thanks
Ezhil

[Yogeeraj_1 · Accepted solution]

hi Ezhil,

You can do it but you will need the control file.

The control file must have a record of all needed backups. If any backups are not listed in the control file, then RMAN cannot restore them. If datafile copies are located on disk but are not in the control file, however, then you can add them to the control file repository with the CATALOG command.

For more detailed explanation, please see: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007319

hope this helps!
regards
Yogeeraj

[Indira Aramandla]

Hi Ezhil,

You can perform complete and incomplete recovery without an RMAN recovery catalog. The difference is many of the RMAN commands are not available without a catalog.

Use nocatalog mode, and rman expects the backup repository information to be in the controlfile itself, so the target database must be mounted

To perform DB point in time recover without a recovery catalog:

1. Start RMAN and connect to the target database, specifying the nocatalog option:

% rman target / nocatalog

2. If the database is open, shut it down and then mount it:
startup force mount

3. Restore a backup controlfile to a temporary location. Restore one of the backup controlfiles that you created as directed in "Back up the control file separately".

Note: If you created a separate control file backup as suggested, RMAN usually restores this backup automatically. RMAN only chooses the wrong backup control file if you specify a time that was in the interval between the backup database and the backup control file.

To ensure that you restore the correct control file, use the tag option on the backup current controlfile command, and then specify this tag on the restore to force RMAN to pick the control file you want.


Indira A

[Yogeeraj_1]

hi again,

please also see metalink note: 61994.1
Subject: Procedures/Restrictions for Point-In-Time Recovery without a Recovery Catalog

this list out the steps quite clearly.

hope this helps too!

good luck

regards
Yogeeraj