redo 无法归档故障处理
英语文化交流 > 技术博客 > redo 无法归档故障处理
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;
随机阅读

Copyright © 2017 英语文化交流 All Rights Reserved.