Joan - Glad to hear your success. In the meanwhile I replied to your earlier message.
Just to clarify, when you used a time-based recovery, setting a time earlier than the most recent backup, RMAN ignored the most recent backup and restored from an earlier backup? Wouldn't that have the disadvantage that you're stuck with a database that doesn't have all the recent transactions applied? Just asking, you're probably suffering from "recovery fatigue" now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, January 09, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Sorry, I tried set until time, it works. Now I think we can move rman to production since we tested all kinds of restore. Thanks and have nice day! Joan Joan Hsieh wrote: > > 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). -- 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: DENNIS WILLIAMS 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).
