ORA-00354,ORA-00353,ORA-00312redo log损坏

xinxin415415

该redo log的状态是非激活，未归档
想使用alter database clear unarchived logfile '/dev/rcrm_redo05'  是否可以？

1. ORA-00354: corrupt redo log block header
   
2. ORA-00353: log corruption near block 1070794 change 13119979989225 time 12/10/2012 20:28:57
   
3. ORA-00312: online log 5 thread 2: '/dev/rcrm_redo05'
   
4. ARC0: All Archive destinations made inactive due to error 354
   
5. Tue Dec 11 11:28:41 2012
   
6. ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/archcrmdb2/crm2_147650_684265335.dbf' (error 354)
   
7. (crmdb2)
   
8. Tue Dec 11 11:29:41 2012
   
9. ARC1: Log corruption near block 1070794 change 13119979989225 time ?
   
10. Tue Dec 11 11:29:41 2012
    
11. Errors in file /oracle/admin/crmdb/bdump/crmdb2_arc1_11042892.trc:
    
12. ORA-00354: corrupt redo log block header
    
13. ORA-00353: log corruption near block 1070794 change 13119979989225 time 12/10/2012 20:28:57
    
14. ORA-00312: online log 5 thread 2: '/dev/rcrm_redo05'
    
15. ARC1: All Archive destinations made inactive due to error 354
    
16. Tue Dec 11 11:29:41 2012
    
17. ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/archcrmdb2/crm2_147650_684265335.dbf' (error 354)
    
18. (crmdb2)
    
19. Tue Dec 11 11:30:42 2012
    
20. ARC0: Log corruption near block 1070794 change 13119979989225 time ?
    
21. Tue Dec 11 11:30:42 2012
    
22. Errors in file /oracle/admin/crmdb/bdump/crmdb2_arc0_9281664.trc:
    
23. ORA-00354: corrupt redo log block header
    
24. ORA-00353: log corruption near block 1070794 change 13119979989225 time 12/10/2012 20:28:57
    
25. ORA-00312: online log 5 thread 2: '/dev/rcrm_redo05'
    
26. ARC0: All Archive destinations made inactive due to error 354
    
27. Tue Dec 11 11:30:43 2012
    
28. ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/archcrmdb2/crm2_147650_684265335.dbf' (error 354)
    
29. (crmdb2)
    
30. Tue Dec 11 11:31:42 2012
    
31. ARC1: Log corruption near block 1070794 change 13119979989225 time ?
    
32. Tue Dec 11 11:31:42 2012
    
33. Errors in file /oracle/admin/crmdb/bdump/crmdb2_arc1_11042892.trc:
    
34. ORA-00354: corrupt redo log block header
    
35. ORA-00353: log corruption near block 1070794 change 13119979989225 time 12/10/2012 20:28:57
    
36. ORA-00312: online log 5 thread 2: '/dev/rcrm_redo05'
    
37. ARC1: All Archive destinations made inactive due to error 354
    
38. Tue Dec 11 11:31:42 2012
    
39. ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/archcrmdb2/crm2_147650_684265335.dbf' (error 354)

复制代码

Liu Maclean(刘相兵

请上传 /oracle/admin/crmdb/bdump/crmdb2_arc1_11042892.trc 以便分析

alter database clear unarchived logfile '/dev/rcrm_redo05'   是解决的一种方法， 但如果clear掉的话 那么无法分析具体原因

shirleylove269

1.首先确认REDO LOG 状态
SQL> select group#,archived,status from v$log;

如果状态为ACTIVE,说明实例恢复时还需要此文件。如果用alter database clear unarchived logfile group ***;会造成数据丢失。
如果状态为INACTIVE,说明实例恢复时不需要此文件，可以用alter database clear logfile group ****;清除此redo log 。

如果REDO LOG 文件损坏，可以考虑DROP REDO LOG 然后重建REDO LOG .
但在DROP REDOLOG 文件之前需要考虑以下条件：
1. 确保每个REDO 组至少有两个成员。
2. 不能drop active or current group member.
3. 在drop 之前确保redo log 归档。