| 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.
At 1st and 3rd?
-----Original Message-----
Sent: Thursday, December 19, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L
Fortunately that is not the real SID name, had to sanitize it before I posted. Realized after I sent it that DB2 was not the best choice. Where are Abbot and Costello when you need them :)
--
Paul
-----Original Message-----
Sent: Thursday, December 19, 2002 2:29 PM
To: ORACLE-L_at_fatcity.com
Cc: pheely_at_progeny.net
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
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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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
--
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 - 14:07:36 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |