Re: RMAN Recovery
- From: Jason Heinrich <jheinrich@xxxxxxxx>
- To: <RWeiss@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 03 May 2007 15:50:57 -0500
Funny, I just read an AskTom post yesterday where he recommended against
naming your redo logs with the .log extension for this very reason.
On 5/3/07 3:01 PM, Rick Weiss wrote:
> 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:
>
>
>
>
>
---------------
Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
(850) 478-8496 x2509
jheinrich@xxxxxxxx
Other related posts:
