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

Cause :-
 This error can occur for lost/corrupted any control file.
In my situation I have unfortunately lost one of control file from two files.

Solution :-
Create pfile from spfile > Edit pfile Change "*.control_files=" parameter. Open database using pfile.

SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> create pfile='D:\pfile.ora' from spfile;

File created.

Now edit pfile
Remove missing control file
SQL> ALTER DATABASE MOUNT;
ALTER DATABASE MOUNT
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info



SQL> SHUTDOWN IMMEDIATE;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> STARTUP PFILE=D:\pfile.ora;
ORACLE instance started.

Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             310378960 bytes
Database Buffers          218103808 bytes
Redo Buffers                5804032 bytes
Database mounted.
Database opened.
SQL>
SQL> create spfile from pfile;

File created.


No comments:

Post a Comment