Re: rman restore question

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On 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: 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: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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).