| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Restoring DB from specific RMAN backup set.
Paul,
Who chose 'DB2' as a SID?
That must be confusing.
DBA1: What are you backing up?
DBA2: DB2 DBA1: What? I thought it was an Oracle database?
DBA2: Yeah it is, DB2.
DBA1: But if it's Oracle, why are you backing up DB2?
DBA2: It's an Oracle database called DB2.
DBA1: But, if you call Oracle DB2, what do you call DB2?
DBA2: DB2. DBA1: ARRRGGHHHHH!! ...
"Paul Heely" <pheely_at_progeny.net>
Sent by: root_at_fatcity.com
12/19/2002 10:17 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: Restoring DB from specific RMAN backup set.
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_at_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. 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 =============== 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 791Received on Thu Dec 19 2002 - 13:37:53 CST
(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: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM 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: 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: INET: Jared.Still_at_radisys.com 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).
 |
 |