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. [EMAIL PROTECTED] -----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 )
