Re: rman restore question

Tanel,

Yes, rman keep asking the newer backupset which is start *450.rman. I don't know the command "change backuupset unavailable" command. I will give it a try. I know there is very rare situration that we need restore from an older backupset, but need to prepare it in case we do need it. I will go sqlserver training for next 3 days. I will post after I get back and tested it out.

Thanks,

joan

Quoting Tanel Poder <tanel.poder.003_at_mail.ee>:

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

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