Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc0_13756.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 16320 change 17258861688 time 07/10/2019 00:11:07
ORA-00312: online log 7 thread 1: 'E:\ORACLE\ORADATA\ORCL\REDO07.LOG'

参考mos id ：332672.1
1、添加redo组及成员

alter database add logfile group 8 'E:\ORACLE\ORADATA\ORCL\REDO08.log' size 200M;alter database add logfile member 'E:\ORACLE\ORADATA\ORCL\REDO081.log' to group 8;

2、查看无法归档redo状态

select GROUP# ,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log; GROUP# SIZE_M STATUS ARC 4 200 INACTIVE YES 5 200 INACTIVE YES 6 200 CURRENT YES 7 200 INACTIVE NO 8 200 UNUSED NO SQL> select member from v$logfile;MEMBER--------------------------------------------------------------------------------E:\ORACLE\ORADATA\ORCL\REDO10.LOGE:\ORACLE\ORADATA\REDO\REDO001.LOGE:\ORACLE\ORADATA\REDO\REDO03.LOGE:\ORACLE\ORADATA\REDO\REDO003.LOG

3、清理redo

alter database clear unarchived logfile group 7;

4、redo 删除

alter database drop logfile group 7;