Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

How to restore database without RMAN catalog ?

SOLVED
Go to solution
ezhilarasan_1
Occasional Advisor

How to restore database without RMAN catalog ?

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
3 REPLIES
Yogeeraj_1
Honored Contributor
Solution

Re: How to restore database without RMAN catalog ?

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Indira Aramandla
Honored Contributor

Re: How to restore database without RMAN catalog ?

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
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: How to restore database without RMAN catalog ?

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)