Paula - Now you've got my attention. Can you describe in more detail what you mean by "editing backup controlfile". I use a backup controlfile to create test databases / validate RMAN backups, so this sounds like something I could use. Thanks.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, August 05, 2003 11:29 AM To: Multiple recipients of list ORACLE-L With DR did use RMAN. Again: (1) using RMAN worked fine from one host to another of same database (2) using cold backup and editing backup controlfile worked fine for same host different database name (3) using RMAN for duplicating one database to same host with different database name in Version 8.1.7.X seemed to require "until...." -----Original Message----- <mailto:[EMAIL PROTECTED]> ] Sent: Tuesday, August 05, 2003 11:39 AM To: Multiple recipients of list ORACLE-L auxi Paula - Okay, when you say you brought the database down, copied the files, etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in that post, but your original post was all about RMAN. -----Original Message----- Sent: Tuesday, August 05, 2003 10:19 AM To: Multiple recipients of list ORACLE-L I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and the bug alluded to using the "until....clause" I feel is the key. BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. -----Original Message----- < mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > ] Sent: Tuesday, August 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L auxi Paula - How is your duplication going? Well I hope. Are you basically trying to perform a disaster recovery? That was basically what I was requested to do. The statement was "imagine the computer room was taken out by terrorists, and all you have are the tapes from the off-site storage. You are provided another server, now recover the database". Is this anything like what you are trying to do? As I recall, DUPLICATE wouldn't work because it just copies the production database, not using the backup tape. With help from a local consultant I accomplished that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, August 04, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Dear Robert, Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work. I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the "backup controlfile to trace" file. This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above. -----Original Message----- < mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> < mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > ] Sent: Monday, August 04, 2003 6:34 PM To: Multiple recipients of list ORACLE-L auxi Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -----Original Message----- < mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> < mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > < mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> < mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > ] Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -----Original Message----- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -----Original Message----- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net <http://www.orafaq.net> > < http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net <http://www.orafaq.net> > > < http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net <http://www.orafaq.net> > < http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net <http://www.orafaq.net> > > > -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com <http://www.fatcity.com> > < http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com <http://www.fatcity.com> > > < http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com <http://www.fatcity.com> > < http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com <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 <http://www.orafaq.net> < http://www.orafaq.net <http://www.orafaq.net> > < http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net <http://www.orafaq.net> > > -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com <http://www.fatcity.com> > < http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com <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 <http://www.orafaq.net> < http://www.orafaq.net <http://www.orafaq.net> > -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com <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 <http://www.orafaq.net> -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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).
