ORA-00205: error in identifying control file while startup database

[#1]

Dear Experts,

we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.

when i startup my database getting error.

SQL> startup mount

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

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

when i checked initSID.ora then found old location of control file.

1)/oracle/SID/sapdata1/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

i have manually changed location of control file.

1)/oracle/SID/sapdata10/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

SQL> Create Pfile from Spfile;

File Created.

i would like to mount my database from Pfile plese help me i execute scripts below.

SQL> STARTUP MOUNT=/oracle/SID/ORACLE_HOME/dbs/initSID.ora

invalid startup option.

or suggest me some other way so that i can startup my Database.

with Regards

[Former Member]

Thanks Deepak for Reply

Earlier

i have startup database in Mount state

SQL> alter system backup controlfile to trace

checked path of each datafile is correct in the trace file.

I have converted sapdata1 to sapdata10 and checked in InitSID.ora file first location of control file is picking old sapdata file.

rest of the 2 control file location is correct.

Steps to Create Control file

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "QAS" NORESETLOGS ARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 1168

LOGFILE

GROUP 1 ('/oracle/SID/origlogA/log_g11m1.dbf','/oracle/QAS/mirrlogA/log_g11m2.dbf') SIZE 75M,

STANDBY LOGFILE

DATAFILE

'/oracle/SID/sapdata10/system_1/system.data1'

'/oracle/SID/sapdata10/undo_1/undo.data1'

'/oracle/SID/sapdata10/sysaux_1/sysaux.data1'

'/oracle/SID/sapdata20/sr3_1/sr3.data1'

'/oracle/SID/sapdata20/sr3_2/sr3.data2'

'/oracle/SID/sapdata20/sr3_3/sr3.data3'

'/oracle/SID/sapdata20/sr3_4/sr3.data4'

'/oracle/SID/sapdata20/sr3_5/sr3.data5'

'/oracle/SID/sapdata20/sr3_6/sr3.data6'

'/oracle/SID/sapdata20/sr3_7/sr3.data7'

'/oracle/SID/sapdata20/sr3_8/sr3.data8'

'/oracle/SID/sapdata20/sr3_9/sr3.data9'

'/oracle/SID/sapdata20/sr3_10/sr3.data10'

'/oracle/SID/sapdata30/sr3701_1/sr3701.data1'

'/oracle/SID/sapdata30/sr3701_2/sr3701.data2'

'/oracle/SID/sapdata30/sr3701_3/sr3701.data3'

'/oracle/SID/sapdata30/sr3701_4/sr3701.data4'

'/oracle/SID/sapdata40/sr3usr_1/sr3usr.data1'

'/oracle/SID/sapdata40/sr3db_1/sr3db.data1'

'/oracle/SID/sapdata40/sr3db_2/sr3db.data2'

'/oracle/SID/sapdata40/sr3db_3/sr3db.data3'

CHARACTER SET UTF8

;

i execute these steps same as way to create control file or some changes in that.

Please suggest correct way to create control file.

With Regards

[Former Member]

Hi,

The steps are fine. Now could you paste the error details from alert_SID.log file once you start your database.

Need to know the error in detail.

Regards,

Deepak Kori