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@xxxxxxxxx
(406) 495-7356

>>> "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rick Weiss
Sent: Thursday, May 03, 2007 12:41 PM
To: oracle-l@xxxxxxxxxxxxx
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:

Other related posts: