Re: rman restore question

Tanel,
Do you mean if I am using current controlfile to recover database, It doesn't matter the backupset is obsolete or not in the rman catalog repository database, is that sounds right? So, I just have to restore the old backupset from tape to disk and issue recover database command? At beginning, I thought to recatalog the backupset, make it valid and then recover from it. However, I couldn't find this kind of operation in manual. So I am wondering how to recover it from an obsolete backupset?
Thanks again,

Joan

Quoting Tanel Poder <tanel.poder.003_at_mail.ee>:

> You can do point in time recovery using current controlfile as well. You
> just say "recover database until cancal using backup controlfile" then, that
> way Oracle ignores SCN information inside controlfile and trusts only
> datafile headers.
>
> You have to open resetlogs after that. One issue I see with this approach is
> that when you have added log/datafiles after your backup, then there'll be
> controlfile/data dictionary mismatch, but it's anyway solvable.
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, December 31, 2003 1:29 AM
>
>
> > Well Roger, Suppose I still have the current control file and want to use
> days
> > old full backupset (obsolete already) to restore and recover the database
> to
> > the point of time. How it related to recover the autobackup controlfile?
> I did
> > configure controlfile autobackup on though.
> >
> > Thanks,
> >
> > Joan
> >
> > Quoting Roger Xu <roger_xu_at_dp7uptx.com>:
> >
> > > I think you can do "CONFIGURE CONTROLFILE AUTOBACKUP ON",
> > > which enables RMAN to automatically backup controlfile to
> > > a default location. Then you can restore the controlfile
> > > before you restore other database files.
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, December 30, 2003 3:34 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > 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).
> > >
> > > For technical support please email tech_support_at_dp7uptx.com or you can
> > > call (972)721-8257.
> > > This email has been scanned for all viruses by the MessageLabs Email
> Security
> > > System.
> > >
> > > ________________________________________________________________________
> > > This email has been scanned for all viruses by the MessageLabs Email
> > > Security System. For more information on a proactive email security
> > > service working around the clock, around the globe, visit
> > > http://www.messagelabs.com
> > > ________________________________________________________________________
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Roger Xu
> > > INET: roger_xu_at_dp7uptx.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).
> > >
> >
> >
> >
> > --
> > 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: Tanel Poder
> INET: tanel.poder.003_at_mail.ee
>
> 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).