Recovering control files from corruption
Controlfile Corruption : --------------------------------------------- Scenario 1 : One of the control files is corrupted -------------------- Starting database with one of the control file corrupted: ------------------------------------------------------------------ SQL> startup ORACLE instance started. Total System Global Area 734003200 bytes Fixed Size 2928728 bytes Variable Size 452988840 bytes Database Buffers 272629760 bytes Redo Buffers 5455872 bytes ORA-00205: error in identifying control file, check alert log for more info Look into the alertlog for errors. The below errors in the alertlog show the controlfile '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl' is corrupted Error in the alert log file: -------------------------------- ALTER DATABASE MOUNT Sun Jan 07 12:01:38 2018 Using default pga_aggregate_limit of 2048 MB Sun Jan 07 12:01:38 2018 ORA-00210: cannot open the s