Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset?
thanks! Joan Ruth Gramolini wrote: > > If you don't set the redundancey policy to a recovery window of N days, than > the record of the backup will be kept indefinitely. You should be able to > restore the backups from tape and restore from a previous backup. You may > need to do a set until time if there was corruption or another problem. > > HTH, > Ruth > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Joan Hsieh > Sent: Tuesday, December 30, 2003 4:34 PM > To: Multiple recipients of list ORACLE-L > Subject: rman restore question > > 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: Ruth Gramolini > 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).
