Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cloning a db

Re: cloning a db

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Thu, 07 Mar 2002 02:40:50 GMT
Message-ID: <SqAh8.207$E22.105147658@newssvr21.news.prodigy.com>


Susott,

Did you shutdown the Oracle services in Services before copying the datafiles?

Also verify that all the dbf files were copied to the correct directories. Also
double check to see if all of them are from the same database. You might have
attempted to create controlfile before copying all the files and then alter added that file.

When you try doing that, it allocates a db_id and after which if we add any new files it considers them to be from a different db and gives the errors received.

So will have to copy all the files before creating the controlfile. In this case you had to copy the datafile all over again and then create the controlfile.

Hope that helps somehow.

Trifon Anguelov
Senior Oracle DBA

Check the latest Oracle DBA forums on:

http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
----------------------------------------------------------------------------
-----------------------------



<SUSOTT_at_amnutrition.com> wrote in message news:u8d9cq8qmpcd80_at_corp.supernews.com...
> Attached are init.ora and ccf.sql(modified trace file).
>
> I am attempting to clone an Oracle database. I have 2 PCs running W2K and
> the database is 8.1.7.0. In accordance with a set of procedures from
> Google, I backed up the control fille to trace and edited it. (Changing
the
> sid name to the new name and added 'set' to the create controlfile.) I
> shutdown the database and then copied all of the data files specified in
the
> trace file to a different location. I copied the trace file and init file
> to the same location. Finished with the origional database, I opened it.
>
> New machine:
> I installed Oracle off of the CD naming the sid with the new name (play).
I
> verified everything was running and even connected from a client machine.
I
> shut down the instance, copied all data files to the location in the trace
> file. Verified I had no reference to the old sid in the init.ora and
trace
> files, and copied them to c:\oracle\admin\play\pfile\*.* (overwriting the
> origional init.ora file.)
> Skipped making the new service as the sid isn't changing.
> performed startup nomount pfile=c:\oracle\admin\play\pfile\init.ora.
> ran the modified trace file to create the new instance.
> This gave me ORA-01161: database name PLAY in file header does not match
> given name of DEV.
> Oracle tells me don't mix data files.
> I then manually tried to open database and received this error
> ORA-01110: data file 1: C:\oracle\oradata\play\SYSTEM01.dbf"
> ORA-01206: file is not part of this database - wrong database id.
>
> Long preface, Questions are: Does the system01.dbf have the instance name
> inside? How can it then be changed? If I don't copy that file, but every
> other file, will that produce a consistant database? What have I missed?
>
>
>
Received on Wed Mar 06 2002 - 20:40:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US