RE: RMAN Recovery

Thanks to all for the help -the FM gave me the quickest work-around:  

RESTORE DATABASE DEVICE TYPE DISK;   I will check the SHOW ALL output and set the configuration to use disk as the default, but I am in the middle of the restore process right now.  The cause of my problem was an erroneous rm *.log that whacked all the redologs by an analyst trying to clean out a bunch of Oracle Warehouse Builder ETL log files.  

Thanks for all of your fine responses, as usual ORACLE-L is the best.      

Rick Weiss
Oracle Database Administrator  

Student Assistance Foundation
P.O.Box 203101
2500 Broadway
Helena, MT 59620-3101  

rweiss_at_safmt.org
(406) 495-7356

>>> "Reidy, Ron" <Ron.Reidy_at_arraybiopharma.com> 5/3/2007 1:48 PM >>>

Rick,We need to see the results of "show all;" from RMAN. My guess is that your recovery catalog thinks the backups are to tape, but your configuration shows disk.rr
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rick Weiss Sent: Thursday, May 03, 2007 12:41 PM
To: oracle-l_at_freelists.org
Subject: RMAN Recovery
 I finally get the chance to recover from a failure and it turns out to be the worst kind - DW (NOARCHIVELOG)  

10.2 on RedHat  

I am using Robert's excellent RMAN book (which was delivered to me from Amazon only a week ago), but my RMAN isn't cooperating. I have good backups from a while back and have done these steps:

- Flushed the data files
- restored my control files
- startup mount; on the database
 

When I try to restore the database from disk backup, RMAN does this:    

--
http://www.freelists.org/webpage/oracle-l