Re: Problem doing RMAN backup of Clone?

2002-11-27 Thread Doug C
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:

Re: Problem doing RMAN backup of Clone?

2002-11-26 Thread Ruth Gramolini
Ditto! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 9:59 AM Good to hear from you Lisa!! Welcome Back!! -Original Message- Sent: Monday, November 25, 2002 7:49 AM To: Multiple recipients of list ORACLE-L

RE: Problem doing RMAN backup of Clone?

2002-11-26 Thread Ron Yount
Doug, I think I may have seen a post that answered this question already, but just to be on the safe side: You cannot backup two databases with the same dbid using the same rman catalog. This always the case with cloned databases unless... 9i - You use the dbid utility to change the dbid of

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Jack van Zanen
Create the clone using RMAN duplicate command. Than it gets new ID -Original Message- Sent: maandag 25 november 2002 4:14 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

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Koivu, Lisa
Title: RE: Problem doing RMAN backup of Clone? Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Jeremiah Wilton
Unfortunately, this problem is with the DBID, not anything in the controlfile. Oracle 9.2 comes with a utility called 'nid' in $ORACLE_HOME/bin/, which can change the DBID of a database. AFAIK, there is no other way to change the DBID, and you just have to use another catalog. I think nid may

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Farnsworth, Dave
Title: RE: Problem doing RMAN backup of Clone? Good to hear from you Lisa!! Welcome Back!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 7:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Problem doing RMAN backup

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Hand, Michael T
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

Re: Problem doing RMAN backup of Clone?

2002-11-25 Thread orafaq
Use following command to generate new dbid. dbms_backup_restore.zeroDbid(0) Read Note:164870.1 on metalink for complete procedure. HTH -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 7:05 AM Unfortunately, this

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Stephen Lee
You can change the DBID as mentioned in other messages. (see metalink doc id 174625.1) If you don't want to change the DBID, you can still backup the database using RMAN; you just can't use the same schema in the same rman catalog database as the original. You can: 1. Use a different catalog

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Freeman, Robert
Also, Oracle9iR2 has a new utility, DBNEWID, that allows you to change the DBID of a copied database safely. With it you can change: 1. The DBID 2. The DBNAME 3. A combination of 1 and 2. This utility is covered in pages 412-413 of my new RMAN book. Prior to 9iR2, you could also use (CAREFULLY)

Problem doing RMAN backup of Clone?

2002-11-24 Thread Doug C
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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat

Problem with RMAN

2001-06-06 Thread Sonja ehovi
List hi! Oracle 8.1.7 EE on WinNT. During instalation of database, package DBMS_RCVCAT was not installed but I have packages DBMS_RCVMAN, DBMS_BACKUP_RESTORE. What should I do? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: