I lost the control file and when trying to start the database I am getting the error below:
SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 8798312 bytes
Variable Size 339742616 bytes
Database Buffers 486539264 bytes
Redo Buffers 3780608 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 8798312 bytes
Variable Size 339742616 bytes
Database Buffers 486539264 bytes
Redo Buffers 3780608 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
You can see that the error is there in alert log as well.
2019-04-27T07:29:30.006425-04:00
ALTER DATABASE MOUNT
2019-04-27T07:29:30.781317-04:00
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl12c/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-205 signalled during: ALTER DATABASE MOUNT...
2019-04-27T07:29:30.932158-04:00
Errors in file /u01/app/oracle/diag/rdbms/orcl12c/orcl12c/trace/orcl12c_m000_12917.trc:
ORA-00202: control file: '/u01/app/oracle/oradata/orcl12c/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2019-04-27T07:29:32.069723-04:00
Checker run found 1 new persistent data failures
Solution: copying the second controlfile over original location and calling it control01.ctl and starting database fixed the issue.
location of the second control file is in the alert log.
control_files = "/u01/app/oracle/oradata/orcl12c/control01.ctl"
control_files = "/u01/app/oracle/fast_recovery_area/orcl12c/control02.ctl"
$ cp /u01/app/oracle/fast_recovery_area/orcl12c/control02.ctl /u01/app/oracle/oradata/orcl12c/control01.ctl
SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 8798312 bytes
Variable Size 339742616 bytes
Database Buffers 486539264 bytes
Redo Buffers 3780608 bytes
Database mounted.
Database opened.
SQL>