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]

Hi User,

As per you question below :

Dear Experts,

connected to idle instance

changed in location of control file in INITSID.ORA

SQL> startup pfile='/oracle/SID/oracle_home/dbs/initSID.ora';

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-00214: control file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3253

inconsistent with file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3218

please suggest what should do

regards

It seems that you have control files of different version in the location specified.

This may happen if you have restored your database due to which one of the controlfiles have been modified (eg. /oracle/SID/sapdata1/cntrl/cntrlPRD.dbf) but the other controlfile locations are untouched. (eg. /oracle/SID/saparch/cntrlPRD.dbf)

Also, in such cases after you make changes (copy the new version on control files) please ensure that the old version is renamed or deleted.

Hope this helps.

Regards,

Nilesh J