Re: rman restore question

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