When the control file file is deleted or its location changes, when you try to run oracle database, we encountered an error like below.
SQL> startup
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
rrent.814.1034955455
Confirm the controlfile name using asmcmd or linux file system by going to the relevant file location.
ASMCMD> ls
current.614.2034955455
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;
System altered.
Close the relevant instance.
SQL> shu immediate;
Restart the relevant instance.
SQL> startup
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.
Tags: