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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: ARRRGGH!! ... "Paul Heely" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2002 10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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@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 IDCUR 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 DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-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 wa
RE: Restoring DB from specific RMAN backup set.
Title: RE: Restoring DB from specific RMAN backup set. Jared, LOL. Sounds like Abbot and Costello doing the DBA version of 'Who's on First'. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 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: ARRRGGH!! ...
RE: Restoring DB from specific RMAN backup set.
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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: ARRRGGH!! ... "Paul Heely" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2002 10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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@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 IDCUR 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 DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-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 O
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: ARRRGGH!! ... "Paul Heely" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2002 10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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@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 IDCUR 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 DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-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 fr
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@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 IDCUR 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 DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-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 'ListG
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. [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 IDCUR 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 DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-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).
Re: Restoring DB from specific RMAN backup set.
As long as you haven't opened the database with resetlogs between the time of the backup you want and the present you can just restore it and recover, using backup controlfile, until cancel. If you have opened it with resetlogs, you will have to change the incarnation of the database, Consult the documentation and if that doesn't help, open a TAR,' HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 10:39 AM > 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 IDCUR 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 DISK15-NOV-02 1 1 > 63 B F A DISK15-NOV-02 1 1 > WORKFLOW_AND_PORTAL > 306 B F A DISK23-NOV-02 1 1 > 314 B F A DISK23-NOV-02 1 1 > 404 B F A DISK26-NOV-02 1 1 > FULL_BACKUP_9014_PATCH > 413 B F A DISK26-NOV-02 1 1 > 729 B F A DISK11-DEC-02 1 1 > FULL_DB_INSTALLED > 749 B F A DISK11-DEC-02 1 1 > 791 B F A DISK18-DEC-02 1 1 WF_TESTING > 811 B F A DISK18-DEC-02 1 1 > 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION > 888 B F A DISK19-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: Ruth Gramolini 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).
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 IDCUR 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 DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-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).