Re: Copying Database to new SID

Hi, Jerry:

I suggest you to create a new oracle instance from scratch (don't use any file from the 1st instance), then use oracle exp/imp utility to duplicate the instance. This way everything is clean.

Hope this helps.

Guang

In article <fstw5.3446$Ds.20164_at_news4.atl>,   "Jerry" <america_at_usa.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 15 2000 - 13:48:42 CDT