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 -> Copying Database to new SID

Copying Database to new SID

From: Jerry <america_at_usa.com>
Date: Fri, 15 Sep 2000 13:00:22 -0500
Message-ID: <fstw5.3446$Ds.20164@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:00:22 CDT

Original text of this message

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