redo 无法归档故障处理

参考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;

redo 无法归档故障处理

原文：https://blog.51cto.com/11298469/2419201