- 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
3, 清理 redo
alter database clear unarchived logfile group 7;
4,redo 删除
alter database drop logfile group 7;
来源: http://www.bubuko.com/infodetail-3120411.html