RE: rman restore question

Joan - I have not used the redundancy policy, but my understanding is this just involves how many backup copies to retain. It does not relate to recovery as I read the manual.

Do you have Robert Freeman's book Oracle9i RMAN Backup & Recovery?

Are you attempting an incomplete recovery or a complete recovery? Any recovery to a time prior to the current time is defined as an incomplete recovery.

If I am recalling your goal, you are trying to recover but not use the latest backup sets. I always back up using an RMAN catalog, but have always tested recovery just using the control file. On Oracle8i I found it easier to separately issue a SQL command to back up the control file after an RMAN backup, then I ensure that control file ends up on the backup tape. This means that I can take the backup tape, restore the control file, then issue RMAN commands that will restore the database. That control file only knows about the RMAN backup that was last performed. So I could restore the data files from any backup. Now, as you know, recovery in RMAN is basically a shell over the Oracle recovery mechanism. You can restore using RMAN, then recover the database using Oracle server manager (now SQL*Plus) commands. So it should be possible to restore the database using RMAN as I described it (but not restore), then replace the old control file with a more recent control file, then recover the database (Oracle will apply archive log files) until the current time is reached. Obviously by starting with an older restore, more archive logs must be applied. Take a look at this idea and see if it would meet your requirements.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, January 09, 2004 8:24 AM
To: Multiple recipients of list ORACLE-L

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