Shulou(Shulou.com)06/01 Report--

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'

Reference mos id: 332672.1

1. Add redo groups and members

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. View redo status that cannot be archived

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. Clean up redo

alter database clear unarchived logfile group 7;

4, redo deleted

alter database drop logfile group 7;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.