Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Restoring DB from specific RMAN backup set.
Paul - Can you specify what you mean by "no archive log mode" and "backed up
with RMAN"? Was the database open?
Which Oracle version?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, December 19, 2002 9:40 AM
To: Multiple recipients of list ORACLE-L
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 servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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). Received on Thu Dec 19 2002 - 10:45:10 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |