redo无法归档故障处理

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.LOG
E:\ORACLE\ORADATA\REDO\REDO001.LOG
E:\ORACLE\ORADATA\REDO\REDO03.LOG
E:\ORACLE\ORADATA\REDO\REDO003.LOG

3、清理redo

alter database clear unarchived logfile group 7;   

4、redo 删除

alter database drop logfile group 7;

网站栏目：redo无法归档故障处理
本文地址：http://bzwzjz.com/article/gidieo.html