System copy issue

[Former Member]

Dears,

I am doing homogeneous system copy from my production system to development system.

I am using ECC5 have windows 2003 server with Oracle 9i.

I have restored the offline back up of production system in development and I am in phase of creating the control file in development system.I have created the script for it from production and changed it as per the development system but when i executing that script in dev to create the control file, I am getting the following error:

SQL> connect / as sysdba

Connected to an idle instance.

SQL> @c:\control.sql

ORACLE instance started.

Total System Global Area 312025176 bytes

Fixed Size 454744 bytes

Variable Size 176160768 bytes

Database Buffers 134217728 bytes

Redo Buffers 1191936 bytes

ORA-00205: error in identifying controlfile, check alert log for more info

CREATE CONTROLFILE SET DATABASE "<SID>" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file

'%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

Beside it status of alert log file is :

System parameters with non-default values:

enqueue_resources = 8000

control_files = H:\oracle\SID\origlogA\cntrl\cntrlSID.dbf, J:\oracle\SID\sapdata1\system_1\cntrl\cntrlSID.dbf, H:\oracle\SID\saparch\cntrl\cntrlSID.dbf

Thu Jun 05 10:45:33 2008

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

ARC0: Archival started

ARC1 started with pid=9

Thu Jun 05 10:45:33 2008

ARCH: STARTING ARCH PROCESSES COMPLETE

Thu Jun 05 10:45:33 2008

ARC0: Thread not mounted

Thu Jun 05 10:45:34 2008

CREATE CONTROLFILE REUSE SET DATABASE "DTP" RESETLOGS ARCHIVELOG

Thu Jun 05 10:45:34 2008

ARC1: Archival started

Thu Jun 05 10:45:34 2008

ARC1: Thread not mounted

Thu Jun 05 10:45:35 2008

ORA-1503 signalled during: CREATE CONTROLFILE REUSE SET DATABASE "DTP" RESETL...

In initsid.ora file parameter

control_files = (H:\oracle\SID\origlogA\cntrl\cntrlSID.dbf, J:\oracle\SID\sapdata1\system_1\cntrl\cntrlSID.dbf, H:\oracle\SID\saparch\cntrl\cntrlSID.dbf)

Please suggest me how can i resolve the issue.

Regards,

Shivam

[Former Member]

The things that catches my mind is:

Have you set the environment parameters ORACLE_HOME and ORACLE_SID ?

Is the CREATE CONTROLFILE command correct ?

The log says

CREATE CONTROLFILE REUSE SET DATABASE "DTP"
 RESETLOGS ARCHIVELOG

But in your case it shoud be

CREATE CONTROLFILE SET DATABASE "DTP" 
RESETLOGS ARCHIVELOG

[Former Member]

Hi Shivam,

Using which tool you restored the database in the Dev system ?

Or you manually copy the files to the appropriate directory ?

Thanks,

Sachin

[andreas_herzog]

a) did you exchange SID with the real system id of your dev system?

> H:\oracle\SID\origlogA\cntrl\cntrlSID.dbf

your sid is DTP so the path should be:

> H:\oracle\DTP\origlogA\cntrl\cntrlDTP.dbf

b) did you open the database as follows before calling control.sql?

> startup nomount

GreetZ, AH