Re: rman restore question

Thanks Tanel. I will test it out.
Happy new year!

Joan

Tanel Poder wrote:
>
> I was actually talking from database recovery point of view (that you can do
> point in time recovery prior to current controlfile time if you use "using
> backup controlfile" option when recovering".
>
> For restoring a de-registered backupset, I see two options (there might be
> more, more convenient ones):
>
> 1) use a old controlfile from the time when the backupset was still
> registered in it (you can create another, temporary recovery catalog and use
> "resync catalog from controlfilecopy 'xxxx'" and then can use restore
> command to read from your old backupset) See metalink note 132927.1 for
> that.
>
> 2) use dbms_backup_restore to manually extract your files from "orphan"
> backupsets (Note 60545.1)
>
> Tanel.
>
> ----- Original Message -----
> To: <ORACLE-L_at_fatcity.com>; "Tanel Poder" <tanel.poder.003_at_mail.ee>
> Cc: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, December 31, 2003 3:55 AM
>
> > 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
>
> --
> 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).