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: <[EMAIL PROTECTED]>; "Tanel Poder" <[EMAIL PROTECTED]>
Cc: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to