Re: Copying Database to new SID

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 16 Sep 2000 06:33:17 +1000
Message-ID: <39c27922$1@news.iprimus.com.au>

There's a db_name parameter in your init.ora. You forgot to edit it to match the new database name in your 'create controlfile' script.

That makes me worry you may have forgot some other things -like the background_dump_dest, the archive log destination directory and so on.

But the proximate cause of the error is the db_name parameter.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Jerry" <america_at_usa.com> wrote in message
news:fstw5.3446$Ds.20164_at_news4.atl...


> I tried to create a copy of my database to a new sid

> by the following method.

>

> 1) Backup control file to trace

> 2) edit the trace file to reflect new Database name and Location

>     of database files.

> 3) Copied all data files to new location

> 4) Copied and edited the Init.ora file to reflect new Sid.

> 5) Rename the trace file to *.sql

> 6) Ran the sql script which should create the new control file.

>

> But got the following errors;

> What step did I miss ?

>

>

>

> ORA-01503: CREATE CONTROLFILE failed

> ORA-01161: database name PROD in file header does not match given name of

> TEST

> ORA-01110: data file 1: 'C:\ORACLE8I\ORADATA\TEST\SYSTEM01.DBF'

> ORA-01507: database not mounted

>

>

>

Received on Fri Sep 15 2000 - 15:33:17 CDT