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:
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
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
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
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
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
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
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
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
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
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)
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
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:
13 matches
Mail list logo