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

[Former Member]

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 · Accepted solution]

Hi,

Can you re-create your controlfile so that it has updated information post movement of datafiles.

Post this try to start your database.

Steps:

1) Startup database in mount state

2) SQL> alter system backup controlfile to trace

3) check whether the path of each datafile is correct in the trace file or not. If required modify the same.

4) Create a control.sql file using the updated trace file

5) create new controlfiles using control.sql script.

In case you want to start your database using pfile use the command

STARTUP MOUNT pf=/oracle/SID/ORACLE_HOME/dbs/initSID.ora

Hope this helps.

Regards,

Deepak Kori