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 <[EMAIL PROTECTED]>: > 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
