restoring controlfile from a backupset after losing spfile and catalog

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 3 Oct 2008 08:24:21 +0000 (GMT)
Message-ID: <180724.2464.qm@web27401.mail.ukl.yahoo.com>


Hi

Yesterday i lost the catalog and there were not controlfile autobackups and also no dbid just a backupset lying on the disk.

I did vaguely remember from the Oracle Press book by Robert Freeman which asked me to use the sys.dbms_backup_restore package to restore the controlfile.

But i still searched and came across the following metalink Note:403883.1

which tells me how to restore a controlfile from backupset using a simple command like

restore controlfile from '/mnt/RMAN_DISK_BACKUP/BKPDB08/c-xxx-xxx-xx';

and the controlfile was restored my question in such a sceanrio whats the use of the package sys.dbms_backup_restore ?

(my only guess is sys.dbms_backup_restore can restore from a tape too)

Any other ideas did my favourite backup and recovery book miss this or i missed it in the book ?

regards
Hrishy       

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 03 2008 - 03:24:21 CDT

Original text of this message