Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Problem doing RMAN backup of Clone?

Re: Problem doing RMAN backup of Clone?

From: Doug C <>
Date: Wed, 27 Nov 2002 22:53:59 -0800
Message-ID: <>

Thanks to everyone .. all useful info.. this procedure worked like a charm!! Thanks a lot!

On Mon, 25 Nov 2002 07:34:16 -0800, you wrote:

>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
>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)
>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
>the same database id as the original. Is this true or not? If so, how to
>around it?
>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:

Please see the official ORACLE-L FAQ:
Author: Doug C

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Nov 28 2002 - 00:53:59 CST

Original text of this message