Re: Copying Database to new SID

The db_name parameter in init<sid>.ora doesn't match the database name in the create controlfile command.

Hth,

Sybrand Bakker, Oracle DBA

"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 - 13:45:54 CDT