RE: rman restore question

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.
dwilliams_at_lifetouch.com

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

-- 
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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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