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

How to fix Oracle

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:

Comments