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> show parameter contr
NAME TYPE VALUE
control_file_record_keep_time integer 7
control_files string D:\APP\ORADATA\DBRMAN\CONTROL0
1.CTL, D:\APP\FLASH_RECOVERY_A
REA\DBRMAN\CONTROL02.CTL
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> create pfile=’D:\pfile.ora’ from spfile;
File created.
Now edit pfile
========== Old Pfile ===========
dbrman.__db_cache_size=218103808
dbrman.__java_pool_size=4194304
dbrman.__large_pool_size=4194304
dbrman.__oracle_base=’D:\app’#ORACLE_BASE set from environment
dbrman.__pga_aggregate_target=255852544
dbrman.__sga_target=381681664
dbrman.__shared_io_pool_size=0
dbrman.__shared_pool_size=146800640
dbrman.__streams_pool_size=0
*.audit_file_dest=’D:\app\admin\DBRMAN\adump’
*.audit_trail=’db’
*.compatible=’11.2.0.0.0′
*.control_files=’D:\app\oradata\DBRMAN\control01.ctl’,’D:\app\oradata\DBRMAN\control02.ctl’
*.db_block_size=8192
*.db_domain=”
*.db_name=’DBRMAN’
*.db_recovery_file_dest=’D:\app\flash_recovery_area’
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest=’D:\app’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DBRMANXDB)’
*.memory_target=634388480
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.undo_tablespace=’UNDOTBS1′
=============== After Editing New Pfile ==================
dbrman.__db_cache_size=218103808
dbrman.__java_pool_size=4194304
dbrman.__large_pool_size=4194304
dbrman.__oracle_base=’D:\app’#ORACLE_BASE set from environment
dbrman.__pga_aggregate_target=255852544
dbrman.__sga_target=381681664
dbrman.__shared_io_pool_size=0
dbrman.__shared_pool_size=146800640
dbrman.__streams_pool_size=0
*.audit_file_dest=’D:\app\admin\DBRMAN\adump’
*.audit_trail=’db’
*.compatible=’11.2.0.0.0′
*.control_files=’D:\app\oradata\DBRMAN\control01.ctl’
*.db_block_size=8192
*.db_domain=”
*.db_name=’DBRMAN’
*.db_recovery_file_dest=’D:\app\flash_recovery_area’
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest=’D:\app’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DBRMANXDB)’
*.memory_target=634388480
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.undo_tablespace=’UNDOTBS1′
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> CONN /AS SYSDBA
Connected to an idle instance.
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=’D:\pfile.ora’;
File created.
