Re: Copy database?

"Karl R" <kroyle_at_hotmail.com> wrote in message news:<c3n2ji$8cq$1$830fa7a5_at_news.demon.co.uk>...
> 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
>

Karl, you are correct in that the SID name is found in the database file header area. The set command changes this name in each of the files defining a given database.

dave
>
>
> "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 - 12:18:47 CST