Oracle 8 and changing DB id's

I had posted this a while back and just wanted to see if anyone has had the same problem.

I have multiple database instances which I copy/clone into other database instances on the same machine. I basically copy the datafiles from one database and then run a create controlfile script which I extract from the source database. Although I would prefer doing it a cleaner way (export/import) the time it takes (5-6 hours) for that vs. the cloning method (10-20min) does not make it feasible.

The problem is that because I am using a straight datafile copy the clone is really a clone of the original, and in Oracle 8 the dbid is not reset which means I can't use rman because rman cannot handle having multiple database instances with the same dbid.

Is there any way to manually change the dbid? Is that OK or will oracle chase me down and beat me in the streets as a example of what not to do?

Any help with this is greatly appreciated, Glen Upreti

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_nau.edu

Received on Tue Jun 29 1999 - 08:57:53 CDT