Re: Problem doing RMAN backup of Clone?
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).
Re: Problem doing RMAN backup of Clone?
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 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 Parkway Ft. Lauderdale, FL, USA 33063 -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 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).
RE: Problem doing RMAN backup of Clone?
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 the clone 8i - You use the dbms_backup_restore.zerodbid(0) (MAKE SURE YOU understand this before implementing it) -Ron- -Original Message- Gramolini Sent: Tuesday, November 26, 2002 8:34 AM To: Multiple recipients of list ORACLE-L 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 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 Parkway Ft. Lauderdale, FL, USA 33063 -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 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount 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).
RE: Problem doing RMAN backup of Clone?
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 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 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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).
RE: Problem doing RMAN backup of Clone?
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 Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Doug C [SMTP: ] Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Subject: Problem doing RMAN backup of Clone? 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 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).
RE: Problem doing RMAN backup of Clone?
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 work on lower version databases, but I am not sure. Check out the docs. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Koivu, Lisa wrote: 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? -Original Message- From: Doug C [SMTP: ] 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? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
RE: Problem doing RMAN backup of Clone?
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 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 Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Doug C [SMTP: ] Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Subject: Problem doing RMAN backup of Clone? 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 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).
RE: Problem doing RMAN backup of Clone?
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).
Re: Problem doing RMAN backup of Clone?
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 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 work on lower version databases, but I am not sure. Check out the docs. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Koivu, Lisa wrote: 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? -Original Message- From: Doug C [SMTP: ] 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? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq 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).
RE: Problem doing RMAN backup of Clone?
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 database. 2. Use a different schema in the same catalog database (for example rman_prod and rman_test schemas). 3. Don't use a catalog, and rely entirely on the control files as your catalog. -Original Message- 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? --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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).
RE: Problem doing RMAN backup of Clone?
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) use the procedure sys.dbms_backup_restore.zerodbid. This is documented in page 395 of my RMAN Backup and Recovery book. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Monday, November 25, 2002 3:24 AM To: Multiple recipients of list ORACLE-L 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 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 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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).
Problem doing RMAN backup of Clone?
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 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).
Problem with RMAN
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: =?windows-1250?Q?Sonja_=8Aehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
