RE: full recovery

AK - This sounds like a disaster recovery test. Be sure to buy Robert Freeman's Oracle9i RMAN Backup & Recovery if you don't have it already. I am on 8.1.6, and had difficulty extracting the control file from the backup (others on this list have done it, this is better on 9i). So I just "cheated" by backing that up after the RMAN backup and restoring it first. That way I can start RMAN and execute a STARTUP MOUNT. You don't say so explicitly, but I'm guessing you're using the control file to run RMAN. I never figured out how to pull the RMAN backup files from a location other than their original path, but fortunately with Unix it is easy to create a link. Can you restore the data files to their original path?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, October 24, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L

Here is a scenerio :
I am taking full database backup everynight using rman to tape . which includes archive logs and control file. Not using catalog.Also have a backup of complete file system including oracle software and configuration files ( init.ora , listener.ora etc.. )
I lost the host on a particular day at 12 am afternoon. Now I want to restore this db to latest possible time to another host ( with same name ) Received on Fri Oct 24 2003 - 14:19:33 CDT