Re: RMAN Recovery Question: Restore with loss of control files and no catalo database

Hi Timothy , I am guessing about the following answers, and I work on 9.2.0.1.0 but anyway here goes :

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

In nomount
First run SET DBID
SET UNTIL SEQUENCE <number> THREAD 1;
Then RESTORE CONTROLFILE ... FROM 'media_handle' or TAG; mount database;
restore database;
recover database ;
open resetlogs database;

Don't know the answer to the second question, let me know if you find out

.............................

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  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).