RE: RMAN Recovery Question: Restore with loss of control files an

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).