Re: Copy database?

Sybrand,

Dave spotted what I was looking for, so no problem now. However, FYI, what I was doing was attempting to create controlfiles for the existing data using a new SID in the CREATE CONTROLFILE command. By forgetting the SET keyword, I was getting the following message, the 3rd line of which suggested (to me) that it was attempting to read the SID from a datafile...

ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name STRCT in file header does not match given name of MIGR
ORA-01110: data file 1: 'C:\oracle\oradata\T\SYSTEM01.DBF'

Thanks

Karl R

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:dldm505l9lcaq2f7di8dpkknjmadejh9f8_at_4ax.com...
> On Fri, 19 Mar 2004 09:17:58 -0000, "Karl R" <kroyle_at_hotmail.com>
> wrote:
>
> >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
> >
>
> Your post is just too vague to get any useful responses.
> Also we are missing out the *exact* steps that got you into this
> situation.
> This sentence
>
> 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).
>
> doesn't tell anything and doesn't make sense as the SID is NOT stored
> anywhere in the database.
> Somehow you screwed this thing up and we can't correct you as we don't
> see anything.
>
>
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Mon Mar 22 2004 - 10:01:56 CST