Re: RMAN Recovery

From: Jason Heinrich <jheinrich_at_pcci.edu>
Date: Thu, 03 May 2007 15:50:57 -0500
Message-ID: <C25FB561.1B5AA%jheinrich@pcci.edu>

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_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:
>
>
>
>
>

---

Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
(850) 478-8496 x2509
jheinrich_at_pcci.edu

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

Received on Thu May 03 2007 - 15:50:57 CDT