Timothy I will tell you what I've figured out. Perhaps someone else can provide additional information. 1. Some people have reported success in extracting the control file from the RMAN backup. I got stuck on the issue that RMAN wouldn't function unless the target instance was up with STARTUP MOUNT, but I couldn't mount the database until I had a control file to mount. I finally gave up and took the expedient of doing a separate SQL BACKUP CONTROLFILE statement, using the RMAN backup directory. To perform a disaster recovery, I just move my copy of the control file into position first. 2. I have not been able to convince RMAN to use a different backup location. Fortunately with Unix it is easy to create a link that looks like the original location.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, June 30, 2003 10:35 AM To: Multiple recipients of list ORACLE-L catalo database Hi there everyone, I have read the documentation and I am missing something, I am stuck on two points: (1) How do I recover from a RMAN backup to disk if I have lost all the original database files (control files, data files and redo logs) (2) How do I change the location for RMAN to check for the backup up file i.e. Backup file was on E: but now in F:, when I enter restore it only checks the original location. Specifications: Oracle 8.1.7.4.10 Windows 2000 SP4 I know that in the backup part I can use the FORMAT string to specify the filename and location. Cheers Tim Clarkson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).