Re: rman restore question

After I did some testing, it is impossble to restore and recover a deleted obsolete backupset. So I took off the delete obsolete command. Retention policy to redundancy still keep it to 1. I did couple backups and run "list backup of database" and "report obsolete" command. Although report obsolet show the backupset but they also shown in list backup of database report and status is valid. Now I have to rephase my question, is it possible to recover from an old backups? I tried restore full, it keep give me the error
and asking the newest backupset which I intend move to somewhere else.

RMAN-03002: failure of restore command at 12/31/2003 15:36:27 ORA-19505: failed to identify file
"/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman" ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory

Joan

Joan Hsieh wrote:
>
> Hi Listers,
>
> I have a question about rman restore. Right now, I configured RETENTION
> POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk
> after a new rman full backup is done. The old backupset will be
> backup-ed to tape by system group. In case of the newly backupset on
> disk is corrupted and need to restore the 2 days old backupset from
> tape. Is there any way or command to restore the database using a
> already deleted obsoleted backupset? (from rman catalog point of view) I
> could find any command and example to restore a obsoleted backupset. Any
> comments will be appreciated.
>
> Many many thanks!
>
> Joan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
> 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: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

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: ListGuru_at_fatcity.com (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).