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> show parameter contr

NAME                                 TYPE        VALUE
———————————— ———– ——————————
control_file_record_keep_time        integer     7
control_files                        string      D:APPORADATADBRMANCONTROL0
1.CTL, D:APPFLASH_RECOVERY_A
READBRMANCONTROL02.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:appadminDBRMANadump’
*.audit_trail=’db’
*.compatible=’11.2.0.0.0′
*.control_files=’D:apporadataDBRMANcontrol01.ctl’,’D:apporadataDBRMANcontrol02.ctl’
*.db_block_size=8192
*.db_domain=”
*.db_name=’DBRMAN’
*.db_recovery_file_dest=’D:appflash_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:appadminDBRMANadump’
*.audit_trail=’db’
*.compatible=’11.2.0.0.0′
*.control_files=’D:apporadataDBRMANcontrol01.ctl’
*.db_block_size=8192
*.db_domain=”
*.db_name=’DBRMAN’
*.db_recovery_file_dest=’D:appflash_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.
Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: