Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Restoring DB from specific RMAN backup set.
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
------- -- -- - ----------- --------------- ------- ------- --- 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-LReceived on Thu Dec 19 2002 - 09:39:41 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).