Doug,
I have successfully tested this method for changing the the dbid {gleaned
from Ron Yount's procedure].Changing the Dbid of copied database: Ron Yount from the Oracle-L provided the following steps if it becomes necessary to change the Dbid of a copied database to allow an RMAN catalog to backup both source and target database. This should occur at the tail of the SAP Database Copy procedure. [Tested successfully on GTS refresh 5/13/02] Use sqlplus to connect internal (if using sqlplus comment # must be changed to 'rem' or '--') SQL> startup nomount SQL> @c.sql /* create controlfile with set database & resetlogs */ SQL> select name,dbid from v$database; (There should be a new name, but same dbid from step 3) SQL> shutdown normal SQL> startup mount SQL> exec dbms_backup_restore.zeroDbid(0); SQL> shutdown normal Rename the control files from the new instance, so they will appear to be missing. SQL> startup nomount SQL> @c.sql SQL> alter database open resetlogs; SQL> select name, dbid from v$database. (There should be the new name, and new dbid) HTH Mike Hand Polaroid Corp. -----Original Message----- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug ****** @@ This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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).
