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