Re: DBID

Yep.. thats correct.. Ran into that issue before, thats why you should use RMAN's duplicate option (not that I've done it..) to create a copy of the database instead of a tradition cloning. I usually get around these issues when my clients do this by creating a seperate schema for every recovery catalog so it won't matter if there is a duplicate DBID.

Tom Tyson

• Tom Pall <tom_at_cdproc.com> wrote:
  > DBID is computed from a seed in the media and the time to create, hopefully,
  > a unique number. I've heard that if you clone a database running in the most
  > recent
  > versions of Oracle, you'll run into problems with some of Oracle's tools
  > (RMAN?).
  > Cloned databases have the same DBID.
  >
  >
  > ----- Original Message -----
  > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
  > Sent: Thursday, November 02, 2000 6:46 AM
  >
  >
  > > Can anyone tell me please how unique is DBID for a database. Is it unique
  > > for every Oracle DB created anywhere, i.e. any O.S. on any machine anywhere
  > > in the world?. Does anyone have any inside track on the algortihm used to
  > > generate the DBID or know of any papers, Web sites with info on same. I've
  > > had a look through Oracle manuals and MetaLink and not found (or missed I
  > > hope!) anything relating to above.
  > >
  > > Sean :)
  > >
  > > ###### ###### ###### ######
  > > # # # # # # # # Rookie
  > > #### # # ###### ###### Data
  > > # # # # # # # # Base
  > > # # ####### ###### # # Adminstrator
  > > -------------------------------- ------------
  > > Organon (Ireland) Ltd.
  > > E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
  > >
  > > Visit: http://www.egroups.com/group/Oracle-OCP-DBA
  > >
  > > The only man who never makes a mistake is the man who never does anything.
  > > - Theodore Roosevelt
  > >
  > > --
  > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > > --
  > > Author: O'Neill, Sean
  > > INET: Sean.ONeill_at_organon.ie
  > >
  > > 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: 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).
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Tom Pall
  > INET: tom_at_cdproc.com
  >
  > 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: 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).