Re: rman restore question

Hi!

As Stephen pointed out, rman searches for a file named "/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman", but can't find it. Is this file a newer backupset which rman is automatically trying to use?

If you want to skip this file, you could use "change backupset unavailable" command for temporarily disabling this newer backupset.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 31, 2003 10:49 PM

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).