我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ，欢迎关注收藏，也欢迎大家转载，但是请在文章开始地方标注文章出处，谢谢！
由于博客中有大量代码，通过页面浏览效果更佳。
Oracle故障处理：ORA-00600: internal error code, arguments: [3020], [5], [13], [20971533]
今天在做实验的时候遇到了ORA-00600: internal error code, arguments: [3020], [5], [13]的错误。故障现象平台：OS:RHEL 4.8 DB:10.2.0.4.12
故障现象:
www.htz.pw >recover datafile 5;
ORA-00279: change 7944639 generated at 06/14/2013 13:40:24 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_878_%u_.arc
ORA-00280: change 7944639 for thread 1 is in sequence #878Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 7944701 generated at 06/14/2013 13:44:43 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_879_%u_.arc
ORA-00280: change 7944701 for thread 1 is in sequence #879
ORA-00278: log file '/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_878_8vocgcqg_.arc' no longer needed for this recovery
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P001
ORA-00600: internal error code, arguments: [3020], [5], [13], [20971533], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 5,
ORA-01112: media recovery not started
故障处理结果：
通过处理，能正常recover数据文件，对坏块的处理，能正常访问块中的数据。
故障处理过程：
1.增加allow 1 corruption正常恢复
这次做了多次allow 1 corruption，因为有多个坏块
www.htz.pw >recover datafile 5 allow 1 corruption;
ORA-00279: change 7945001 generated at 06/14/2013 13:49:53 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_879_%u
_.arc
ORA-00280: change 7945001 for thread 1 is in sequence #879Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 7945117 generated at 06/14/2013 13:55:29 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_880_%u
_.arc
ORA-00280: change 7945117 for thread 1 is in sequence #880
ORA-00278: log file
'/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_879_8
vod2kn1_.arc' no longer needed for this recoveryORA-00279: change 7945357 generated at 06/14/2013 13:58:26 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_881_%u
_.arc
ORA-00280: change 7945357 for thread 1 is in sequence #881
ORA-00278: log file
'/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_880_8
vod82nm_.arc' no longer needed for this recoveryORA-00279: change 7945360 generated at 06/14/2013 13:58:29 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_882_%u
_.arc
ORA-00280: change 7945360 for thread 1 is in sequence #882
ORA-00278: log file
'/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_881_8
vod85pj_.arc' no longer needed for this recoveryORA-00279: change 7945362 generated at 06/14/2013 13:58:32 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_883_%u
_.arc
ORA-00280: change 7945362 for thread 1 is in sequence #883
ORA-00278: log file
'/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_882_8
vod88pv_.arc' no longer needed for this recoveryORA-00279: change 7945364 generated at 06/14/2013 13:58:32 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_884_%u
_.arc
ORA-00280: change 7945364 for thread 1 is in sequence #884
ORA-00278: log file
'/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2013_06_14/o1_mf_1_883_8
vod88q2_.arc' no longer needed for this recoveryLog applied.
Media recovery complete.
2，online数据文件
alter database datafile 5 online;
3,对相关表的访问，报坏块的错误
使用bbed修复坏块
BBED> p kcbh
struct kcbh, 20 bytes @0 ub1 type_kcbh @0 0x06ub1 frmt_kcbh @1 0xa2ub1 spare1_kcbh @2 0x00ub1 spare2_kcbh @3 0x00ub4 rdba_kcbh @4 0x010003bcub4 bas_kcbh @8 0x00000000ub2 wrp_kcbh @12 0x0000ub1 seq_kcbh @14 0xffub1 flg_kcbh @15 0x04 (KCBHFCKV)ub2 chkval_kcbh @16 0xf035ub2 spare3_kcbh @18 0x0000BBED> p tailchk
ub4 tailchk @8188 0x000006ffmodify /x 01 dba 5,16 offset 14
modify /x 01 dba 5,17 offset 14
modify /x 01 dba 5,18 offset 14
modify /x 01 dba 5,19 offset 14
modify /x 01 dba 5,20 offset 14
modify /x 01 dba 5,21 offset 14
modify /x 01 dba 5,22 offset 14
modify /x 01 dba 5,16 offset 8188
modify /x 01 dba 5,17 offset 8188
modify /x 01 dba 5,18 offset 8188
modify /x 01 dba 5,19 offset 8188
modify /x 01 dba 5,20 offset 8188
modify /x 01 dba 5,21 offset 8188
modify /x 01 dba 5,22 offset 8188
sum apply
修改完成后，
alter database datafile 5 offline;
recover datafile 5;
alter database datafile 5 online;
通过处理后,数据能正常访问,并且里面的数据也没有丢失.
------------------作者介绍-----------------------
姓名：黄廷忠
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)