ORA-00205 error in identifying control file, check alert log for more info
When the control file file is deleted or its location changes, when you try to run oracle database, we encountered an error like below.
ORACLE instance started.
ORA-00205: error in identifying control file, check alert log for more info
See control file location
show parameter control_files
NAME TYPE VALUE
control_files string +DATAC/TESTDB/CONTROLFILE/cu
Confirm the controlfile name using asmcmd or linux file system by going to the relevant file location.
If the Controlfile file does not match the parameter location, update with the correct location command.
SQL> alter system set control_files=’ +DATAC/TESTDB/CONTROLFILE/ current.614.2034955455 ‘ scope=spfile;
Close the relevant instance.
SQL> shu immediate;
Restart the relevant instance.
The database was opened with the following control file.
SQL> show parameter control_files;
control_files string +DATAC/ TESTDB/CONTROLFILE/current.614.2034955455
Congrat, have a nice day.