Thanks to everyone .. all useful info.. this procedure worked like a charm!!
Thanks a lot!
- Dc.
On Mon, 25 Nov 2002 07:34:16 -0800, you wrote:
>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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Doug C
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).
