Re: rman restore question

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