RE: Problem doing RMAN backup of Clone?

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Mon, 25 Nov 2002 07:34:16 -0800
Message-ID: <F001.0050AC16.20021125073416@fatcity.com>

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: HANDM_at_polaroid.com

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: ListGuru_at_fatcity.com (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 Mon Nov 25 2002 - 09:34:16 CST