Re: Restoring DB from specific RMAN backup set.

As long as you haven't opened the database with resetlogs between the time of the backup you want and the present you can just restore it and recover, using backup controlfile, until cancel.
If you have opened it with resetlogs, you will have to change the incarnation of the database, Consult the documentation and if that doesn't help, open a TAR,'

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, December 19, 2002 10:39 AM

> How can I restore a database from a specific RMAN backup set? We have a
> database running in no archive log mode that is backed up with RMAN.
> There is an RMAN catalog DB also.
>
> If I look at the backup summary I see:
> List of Database Incarnations
> DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
> ------- ------- -------- ---------------- --- ---------- ----------
> 37 38 DB2 1600772452 NO 1 15-NOV-02
> 37 256 DB2 1600772452 NO 259591 23-NOV-02
> 37 627 DB2 1600772452 NO 792890 11-DEC-02
> 37 654 DB2 1600772452 NO 792890 11-DEC-02
> 37 712 DB2 1600772452 NO 792890 11-DEC-02
> 37 680 DB2 1600772452 NO 792890 11-DEC-02
> 37 764 DB2 1600772452 NO 823456 11-DEC-02
> 37 816 DB2 1600772452 YES 823456 18-DEC-02
> 37 893 DB2 1600772452 NO 823456 19-DEC-02
>
> The backup summary list looks like:
> List of Backups
> ===============
> Key TY LV S Device Type Completion Time #Pieces #Copies Tag
> ------- -- -- - ----------- --------------- ------- ------- ---
> 47 B F A DISK 15-NOV-02 1 1
> 63 B F A DISK 15-NOV-02 1 1
> WORKFLOW_AND_PORTAL
> 306 B F A DISK 23-NOV-02 1 1
> 314 B F A DISK 23-NOV-02 1 1
> 404 B F A DISK 26-NOV-02 1 1
> FULL_BACKUP_9014_PATCH
> 413 B F A DISK 26-NOV-02 1 1
> 729 B F A DISK 11-DEC-02 1 1
> FULL_DB_INSTALLED
> 749 B F A DISK 11-DEC-02 1 1
> 791 B F A DISK 18-DEC-02 1 1 WF_TESTING
> 811 B F A DISK 18-DEC-02 1 1
> 867 B F A DISK 19-DEC-02 1 1 SW_MIGRATION
> 888 B F A DISK 19-DEC-02 1 1
>
> I've tried resetting the database to incarnation 816, but when I restore
> the control file and data files from that it is not what I think it
> should be. I end up with FULL_DB_INSTALLED. I can restore the control
> file I want from the auto backup file. How can I then tell RMAN to
> restore the data files associated with either backup set 791
> (tag=WF_TESTING)?
>
> Thanks.
> --
> Paul
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Paul Heely
> INET: pheely_at_progeny.net
>
> 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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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