I am having issues getting my database to work after a power failure. It is oracle 11.2. Below are things I have tried from reading blogs and other discussions, but I am unable to get the redo logs fixed. There is only one tablespace that I care about on the system. Does anyone have any suggestions that I can try?
SQL> alter system dump logfile '/disk1/oracle/product/11.2.0/oradata/ciqorcl1/redo01.log' validate;
alter system dump logfile '/disk1/oracle/product/11.2.0/oradata/ciqorcl1/redo01.log' validate
*
ERROR at line 1:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1422 change 154081393 time 05/22/2018
10:02:09
ORA-00334: archived log:
'/disk1/oracle/product/11.2.0/oradata/ciqorcl1/redo01.log'
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance ciqorcl1 (thread 1)
ORA-00312: online log 1 thread 1:
'/disk1/oracle/product/11.2.0/oradata/ciqorcl1/redo01.log'
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
CIQORCL1 MOUNTED
SQL> col FIRST_CHANGE# format 99999999999999;
SQL> select group#,status,archived,sequence#,first_change# from v$log;
GROUP# STATUS ARC SEQUENCE# FIRST_CHANGE#
---------- ---------------- --- ---------- ---------------
1 ACTIVE NO 14593 154081385
3 INACTIVE NO 14592 154080930
2 CURRENT NO 14594 154081826
bash-3.2$ ls -l | grep redo
-rw-r----- 1 oracle dba 52429312 May 22 10:02 redo01.log
-rw-r----- 1 oracle dba 52429312 May 22 10:02 redo02.log
-rw-r----- 1 oracle dba 52429312 May 22 10:02 redo03.log