found a note on metalink about how to change the dbid by recreating the
controlfile (note 174625.1) . . . one of those notes with the lovely
disclaimer about how the script is not supported by Oracle support, done at
your own risk, don't try this on a production db, etc. . . .
anyway, it worked just fine and I was able to register the second db in the
catalog.
why would it give me more flexibility to use a separate catalog for each
prod database? (also, we're a dev shop - only db's in use here are for app
dev and qa)
any and all thoughts are appreciated
tx
-----Original Message-----
Sent: Thursday, May 30, 2002 12:11 PM
To: Multiple recipients of list ORACLE-L
Bill
Perhaps you created one by cloning it from the other one. This can
change the SID, but won't change the DB_ID. RMAN can't deal with multiple
instances with the same DB_ID. The simplest way around this is to create a
separate RMAN catalog for one of them (just create a separate username).
Actually, I'm becoming convinced that maybe the way to go is to create a
separate catalog for each production database. This gives you more
flexibility, and I haven't seem any disadvantages to this.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, May 30, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
I'm just starting to set up RMAN (8.1.7+) . . .
I'm registering all of my databases one by one from the command line.
I have two db's on the same solaris box and when I run the rman command they
both show up with the same DB_ID, thus preventing me from registering both
of them . . . I get an error when registering the second that it's already
registered.
they are distinct db's . . .
I tried unregistering one and then retrying, and again I get the same DBID
for both.
any ideas?
thanks, y'all
-bill
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Magaliff, Bill
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Magaliff, Bill
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).
