Copy database?

Hi,

I need to create a copy of my existing database as part of a migration process. However, it can only be run on the same server so I need to change the SID. The database is about 100GB and running on an NT4 server.

I tried using oradim -new, copying the data files and recreating the control files for the new location/SID. This works fine on a different server using the same SID but it complains of a mismatch when I try it on the same machine using a new SID in the control files (the SID seems to be embedded in the data files too). If this could be made to work it would be ideal since it's fast and I get an exact copy.

I've also tried creating a new database, then recreating the users manually (of which there are hundreds) from dba_users then doing and exp and imp of the whole DB from the original database. This is slow (overnight) and tends to fall over half way through (IMP-00003: /ORA-03113: end-of-file on communication channel, no useful log file entries).

Any suggestions on why these don't work / ways to make them work gratefully received! Alternatively, if there's a better way of doing this, please let me know!

Thanks in advance

Karl R Received on Fri Mar 19 2004 - 03:17:58 CST