Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode.
The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format="f:\oracle_backup\%d\%d_%U" tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -----Original Message----- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L 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. [EMAIL PROTECTED] -----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 =============== 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely 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).