一套10.2.0.4的單節(jié)點(diǎn)數(shù)據(jù)庫(kù)在恢復(fù)數(shù)據(jù)文件時(shí)出現(xiàn)了ORA-00600: internal error code, arguments: [2608], [1], [0], [690423], [0], [690425], [], []內(nèi)部錯(cuò)誤，其日志如下: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /s01/db_1 System name: Linux Node name: rh2.oracle.com Release: 2.6.18-194.el5 Version: #1 SMP Mon Mar 29 22:10:29 EDT 2010 Machine: x86_64 Instance name: G10R2 Redo thread mounted by this instance: 1 Oracle process number: 15 Unix process pid: 21360, image: oracle@rh2.oracle.com (TNS V1-V3)*** 2011-04-27 21:20:40.979 *** ACTION NAME:() 2011-04-27 21:20:40.979 *** MODULE NAME:(sqlplus@rh2.oracle.com (TNS V1-V3)) 2011-04-27 21:20:40.979 *** SERVICE NAME:(SYS$USERS) 2011-04-27 21:20:40.979 *** SESSION ID:(159.3) 2011-04-27 21:20:40.979 kwqmnich: current time:: 13: 20: 40 kwqmnich: instance no 0 check_only flag 1 kwqmnich: initialized job cache structure Recovery target incarnation = 2, activation ID = 0 Influx buffer limit = 52443 (50% x 104887) Successfully allocated 2 recovery slaves Using 550 overflow buffers per recovery slave Start recovery at thread 1 ckpt scn 690423 logseq 1 block 3183 *** 2011-04-27 21:20:46.165 Media Recovery add redo thread 1 *** 2011-04-27 21:20:46.172 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [2608], [1], [0], [690423], [0], [690425], [], [] Current SQL statement for this session: ALTER DATABASE RECOVER datafile 9 ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst()+31 call ksedst1() 000000000 ? 000000001 ? ksedmp()+610 call ksedst() 000000000 ? 000000001 ?7FFF6F1795E0 ? 7FFF6F179640 ?7FFF6F179580 ? 000000000 ? ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?7FFF6F1795E0 ? 7FFF6F179640 ?7FFF6F179580 ? 000000000 ? kgeriv()+176 call ksfdmp() 000000003 ? 000000001 ?7FFF6F1795E0 ? 7FFF6F179640 ?7FFF6F179580 ? 000000000 ? kgesiv()+119 call kgeriv() 0068966E0 ? 00A81E650 ?000000000 ? 7FFF6F178F08 ?7FFF6F179580 ? 000000000 ? ksesic5()+215 call kgesiv() 0068966E0 ? 00A81E650 ?000000A30 ? 000000005 ?7FFF6F17A360 ? 000000000 ? kcrfro()+6796 call ksesic5() 000000A30 ? 000000000 ?000000001 ? 000000000 ?000000000 ? 000000000 ? kcramr()+7872 call kcrfro() 2B9DB2D29400 ? 000000000 ?000000001 ? 000000000 ?000000000 ? 000000000 ? krddmr()+1290 call kcramr() 2B9DB2CF70E0 ? 00A7F8280 ?000000000 ? 000000000 ?000000000 ? 000000000 ? adbdrv()+10248 call krddmr() 00A7F8280 ? 000000000 ?7FFF6F182FC4 ? 000000000 ?2B9DB2CF70E0 ?A7F828000000001 ? opiexe()+13505 call adbdrv() 00A7F8280 ? 000000000 ?0A2806BD8 ? 000000000 ?2B9DB2CF70E0 ?A7F828000000001 ? opiosq0()+3316 call opiexe() 000000004 ? 000000000 ?7FFF6F184238 ? 000000012 ?2B9DB2CF70E0 ?A7F828000000001 ? kpooprx()+315 call opiosq0() 000000003 ? 00000000E ?7FFF6F1843A8 ? 0000000A4 ?2B9DB2CF70E0 ?A7F828000000001 ? kpoal8()+799 call kpooprx() 7FFF6F187554 ? 7FFF6F185530 ?000000024 ? 000000001 ?000000000 ? A7F828000000001 ? opiodr()+984 call kpoal8() 00000005E ? 000000017 ?7FFF6F187550 ? 000000001 ?000000001 ? A7F828000000001 ? ttcpip()+1012 call opiodr() 00000005E ? 000000017 ?7FFF6F187550 ? 000000000 ?0059C0990 ? A7F828000000001 ? opitsk()+1322 call ttcpip() 00689E3B0 ? 000000001 ?7FFF6F187550 ? 000000000 ?7FFF6F187048 ? 7FFF6F1876B8 ? opiino()+1026 call opitsk() 000000003 ? 000000000 ?7FFF6F187550 ? 000000001 ? ========================================================= 該ORA-00600[2608]可能由數(shù)據(jù)文件頭中記錄的checkpoint scn過(guò)小造成，Oracle會(huì)將該checkpoint scn與塊中的resetlogs scn以及控制文件中記錄的日志文件的Low scn相比較，若文件頭中的checkpoint scn遠(yuǎn)小于對(duì)比值，那么就會(huì)出現(xiàn)ORA-00600[2608]內(nèi)部錯(cuò)誤。 下面我們通過(guò)修改數(shù)據(jù)文件頭中kcvfhckp結(jié)構(gòu)中記錄的checkpoint scn到一個(gè)較小值，來(lái)模擬出發(fā)ORA-00600[2608]內(nèi)部錯(cuò)誤: SQL> oradebug setmypid; Statement processed.SQL> oradebug dump file_hdrs 8; Statement processed.SQL> oradebug tracefile_name;DATA FILE #11:(name #17) /u01/data02.dbf creation size=6400 block size=8192 status=0x1c head=17 tail=17 dup=1tablespace 12, index=12 krfil=11 prev_file=0unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00Checkpoint cnt:4 scn: 0x0000.000b01c2 04/27/2011 22:52:31Stop scn: 0x0000.000b01c5 04/27/2011 22:52:39Creation Checkpointed at scn: 0x0000.000b01a8 04/27/2011 22:52:24thread:1 rba:(0xb.e.10) ....................................................Hot Backup end marker scn: 0x0000.00000000aux_file is NOT DEFINEDV10 STYLE FILE HEADER:Compatibility Vsn = 169870080=0xa200300Db ID=2894437650=0xac859d12, Db Name='G10R2'Activation ID=0=0x0Control Seq=740=0x2e4, File size=6400=0x1900File Number=11, Blksiz=8192, File Type=3 DATA Tablespace #12 - DATA02 rel_fn:11 Creation at scn: 0x0000.000b01a8 04/27/2011 22:52:24 Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0reset logs count:0x2cade887 scn: 0x0000.000a88f9 reset logs terminal rcv data:0x0 scn: 0x0000.00000000prev reset logs count:0x2cadd4e7 scn: 0x0000.000a7f86 prev reset logs terminal rcv data:0x0 scn: 0x0000.00000000recovered at 01/01/1988 00:00:00status:0x4 root dba:0x00000000 chkpt cnt: 4 ctl cnt:3 begin-hot-backup file size: 0 Checkpointed at scn: 0x0000.000b01c2 04/27/2011 22:52:31/* 可以看到以上11號(hào)數(shù)據(jù)文件頭的Checkpoint scn為0x0000.000b01c2 ,而resetlogs scn為0x0000.000a88f9 *//* 我們將Checkpoint scn修改為0x0000.000a88f7 */[oracle@rh2 u01]$ bbed filename=data02.dbf blocksize=8192 password=blockedit mode=editBBED: Release 2.0.0.0.0 - Limited Production on Wed Apr 27 22:55:30 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.************* !!! For Oracle Internal Use only !!! *************** BBED> set blocksize 8192BLOCKSIZE 8192BBED> set block 2BLOCK# 2BBED> mapFile: data02.dbf (0)Block: 2 Dba:0x00000000 ------------------------------------------------------------Data File Headerstruct kcvfh, 676 bytes @0 ub4 tailchk @8188 BBED> p kcvfh struct kcvfh, 676 bytes @0 struct kcvfhbfh, 20 bytes @0 ub1 type_kcbh @0 0x0bub1 frmt_kcbh @1 0xa2ub1 spare1_kcbh @2 0x00ub1 spare2_kcbh @3 0x00ub4 rdba_kcbh @4 0x02c00001ub4 bas_kcbh @8 0x00000000ub2 wrp_kcbh @12 0x0000ub1 seq_kcbh @14 0x01ub1 flg_kcbh @15 0x04 (KCBHFCKV)ub2 chkval_kcbh @16 0xb4a1ub2 spare3_kcbh @18 0x0000struct kcvfhhdr, 76 bytes @20 ub4 kccfhswv @20 0x00000000ub4 kccfhcvn @24 0x0a200300ub4 kccfhdbi @28 0xac859d12text kccfhdbn[0] @32 Gtext kccfhdbn[1] @33 1text kccfhdbn[2] @34 0text kccfhdbn[3] @35 Rtext kccfhdbn[4] @36 2text kccfhdbn[5] @37 text kccfhdbn[6] @38 text kccfhdbn[7] @39 ub4 kccfhcsq @40 0x000002e4ub4 kccfhfsz @44 0x00001900s_blkz kccfhbsz @48 0x00ub2 kccfhfno @52 0x000bub2 kccfhtyp @54 0x0003ub4 kccfhacid @56 0x00000000ub4 kccfhcks @60 0x00000000text kccfhtag[0] @64 text kccfhtag[1] @65 text kccfhtag[2] @66 text kccfhtag[3] @67 text kccfhtag[4] @68 text kccfhtag[5] @69 text kccfhtag[6] @70 text kccfhtag[7] @71 text kccfhtag[8] @72 text kccfhtag[9] @73 text kccfhtag[10] @74 text kccfhtag[11] @75 text kccfhtag[12] @76 text kccfhtag[13] @77 text kccfhtag[14] @78 text kccfhtag[15] @79 text kccfhtag[16] @80 text kccfhtag[17] @81 text kccfhtag[18] @82 text kccfhtag[19] @83 text kccfhtag[20] @84 text kccfhtag[21] @85 text kccfhtag[22] @86 text kccfhtag[23] @87 text kccfhtag[24] @88 text kccfhtag[25] @89 text kccfhtag[26] @90 text kccfhtag[27] @91 text kccfhtag[28] @92 text kccfhtag[29] @93 text kccfhtag[30] @94 text kccfhtag[31] @95 ub4 kcvfhrdb @96 0x00000000struct kcvfhcrs, 8 bytes @100 ub4 kscnbas @100 0x000b01a8ub2 kscnwrp @104 0x0000ub4 kcvfhcrt @108 0x2cae0628ub4 kcvfhrlc @112 0x2cade887struct kcvfhrls, 8 bytes @116 resetlogs scnub4 kscnbas @116 0x000a88f9ub2 kscnwrp @120 0x0000ub4 kcvfhbti @124 0x00000000struct kcvfhbsc, 8 bytes @128 ub4 kscnbas @128 0x00000000ub2 kscnwrp @132 0x0000ub2 kcvfhbth @136 0x0000ub2 kcvfhsta @138 0x0004 (KCVFHOFZ)struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 checkpoint scn ub4 kscnbas @484 0x000b01c2ub2 kscnwrp @488 0x0000ub4 kcvcptim @492 0x2cae062fub2 kcvcpthr @496 0x0001union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x0000000bub4 kcrbabno @504 0x0000001bub2 kcrbabof @508 0x0010ub1 kcvcpetb[0] @512 0x02ub1 kcvcpetb[1] @513 0x00ub1 kcvcpetb[2] @514 0x00ub1 kcvcpetb[3] @515 0x00ub1 kcvcpetb[4] @516 0x00ub1 kcvcpetb[5] @517 0x00ub1 kcvcpetb[6] @518 0x00ub1 kcvcpetb[7] @519 0x00ub4 kcvfhcpc @140 0x00000004ub4 kcvfhrts @144 0x00000000ub4 kcvfhccc @148 0x00000003struct kcvfhbcp, 36 bytes @152 struct kcvcpscn, 8 bytes @152 ub4 kscnbas @152 0x00000000ub2 kscnwrp @156 0x0000ub4 kcvcptim @160 0x00000000ub2 kcvcpthr @164 0x0000union u, 12 bytes @168 struct kcvcprba, 12 bytes @168 ub4 kcrbaseq @168 0x00000000ub4 kcrbabno @172 0x00000000ub2 kcrbabof @176 0x0000ub1 kcvcpetb[0] @180 0x00ub1 kcvcpetb[1] @181 0x00ub1 kcvcpetb[2] @182 0x00ub1 kcvcpetb[3] @183 0x00ub1 kcvcpetb[4] @184 0x00ub1 kcvcpetb[5] @185 0x00ub1 kcvcpetb[6] @186 0x00ub1 kcvcpetb[7] @187 0x00ub4 kcvfhbhz @312 0x00000000struct kcvfhxcd, 16 bytes @316 ub4 space_kcvmxcd[0] @316 0x00000000ub4 space_kcvmxcd[1] @320 0x00000000ub4 space_kcvmxcd[2] @324 0x00000000ub4 space_kcvmxcd[3] @328 0x00000000word kcvfhtsn @332 12ub2 kcvfhtln @336 0x0006text kcvfhtnm[0] @338 Dtext kcvfhtnm[1] @339 Atext kcvfhtnm[2] @340 Ttext kcvfhtnm[3] @341 Atext kcvfhtnm[4] @342 0text kcvfhtnm[5] @343 2text kcvfhtnm[6] @344 text kcvfhtnm[7] @345 text kcvfhtnm[8] @346 text kcvfhtnm[9] @347 text kcvfhtnm[10] @348 text kcvfhtnm[11] @349 text kcvfhtnm[12] @350 text kcvfhtnm[13] @351 text kcvfhtnm[14] @352 text kcvfhtnm[15] @353 text kcvfhtnm[16] @354 text kcvfhtnm[17] @355 text kcvfhtnm[18] @356 text kcvfhtnm[19] @357 text kcvfhtnm[20] @358 text kcvfhtnm[21] @359 text kcvfhtnm[22] @360 text kcvfhtnm[23] @361 text kcvfhtnm[24] @362 text kcvfhtnm[25] @363 text kcvfhtnm[26] @364 text kcvfhtnm[27] @365 text kcvfhtnm[28] @366 text kcvfhtnm[29] @367 ub4 kcvfhrfn @368 0x0000000bstruct kcvfhrfs, 8 bytes @372 ub4 kscnbas @372 0x00000000ub2 kscnwrp @376 0x0000ub4 kcvfhrft @380 0x00000000struct kcvfhafs, 8 bytes @384 ub4 kscnbas @384 0x00000000ub2 kscnwrp @388 0x0000ub4 kcvfhbbc @392 0x00000000ub4 kcvfhncb @396 0x00000000ub4 kcvfhmcb @400 0x00000000ub4 kcvfhlcb @404 0x00000000ub4 kcvfhbcs @408 0x00000000ub2 kcvfhofb @412 0x0000ub2 kcvfhnfb @414 0x0000ub4 kcvfhprc @416 0x2cadd4e7struct kcvfhprs, 8 bytes @420 ub4 kscnbas @420 0x000a7f86ub2 kscnwrp @424 0x0000struct kcvfhprfs, 8 bytes @428 ub4 kscnbas @428 0x00000000ub2 kscnwrp @432 0x0000ub4 kcvfhtrt @444 0x00000000BBED> set offset 484OFFSET 484BBED> p pad --- ub1 pad @484 0xc2BBED> modify /x f788 Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) yFile: data02.dbf (0)Block: 2 Offsets: 484 to 995 Dba:0x00000000 ------------------------------------------------------------------------f7880b00 00000000 2f06ae2c 01000000 0b000000 1b000000 1000e880 02000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0d000d00 0d000100 00000000 00000000 00000000 0200c002 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 <32 bytes per line>BBED> set offset 486OFFSET 486BBED> p pad --- ub1 pad @486 0x00BBED> modify /x 0x0a00File: data02.dbf (0)Block: 2 Offsets: 486 to 997 Dba:0x00000000 ------------------------------------------------------------------------0a000000 00002f06 ae2c0100 00000b00 00001b00 00001000 e8800200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000d00 0d000d00 01000000 00000000 00000000 00000200 c0020000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 <32 bytes per line>BBED> p kcvfhckp struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 ub4 kscnbas @484 0x000a88f7ub2 kscnwrp @488 0x0000ub4 kcvcptim @492 0x2cae062fub2 kcvcpthr @496 0x0001union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x0000000bub4 kcrbabno @504 0x0000001bub2 kcrbabof @508 0x0010ub1 kcvcpetb[0] @512 0x02ub1 kcvcpetb[1] @513 0x00ub1 kcvcpetb[2] @514 0x00ub1 kcvcpetb[3] @515 0x00ub1 kcvcpetb[4] @516 0x00ub1 kcvcpetb[5] @517 0x00ub1 kcvcpetb[6] @518 0x00ub1 kcvcpetb[7] @519 0x00BBED> sum Check value for File 0, Block 2: current = 0xb4a1, required = 0x3d95BBED> sum apply Check value for File 0, Block 2: current = 0x3d95, required = 0x3d95/* 如我們所期待地出現(xiàn)了ORA-00600[2608]內(nèi)部錯(cuò)誤 */SQL> recover datafile 11; ORA-00283: recovery session canceled due to errors ORA-00600: internal error code, arguments: [2608], [2], [0], [690423], [0], [721306], [], []這里的690423也就是16進(jìn)制的0x000a88f7，是我們之前所修改的checkpoint scn， 而721306等于0xb019a，為當(dāng)前日志文件的Low scn: LOG FILE #1:(name #5) /flashcard/oradata/G10R2/onlinelog/o1_mf_1_6v34jnkn_.log(name #6) /s01/flash_recovery_area/G10R2/onlinelog/o1_mf_1_6v34jnst_.logThread 1 redo log links: forward: 2 backward: 0siz: 0x19000 seq: 0x0000000a hws: 0x2 bsz: 512 nab: 0x2 flg: 0x1 dup: 2Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0193Low scn: 0x0000.000b0196 04/27/2011 22:52:05Next scn: 0x0000.000b019a 04/27/2011 22:52:10 LOG FILE #2:(name #3) /flashcard/oradata/G10R2/onlinelog/o1_mf_2_6v34jokt_.log(name #4) /s01/flash_recovery_area/G10R2/onlinelog/o1_mf_2_6v34jotq_.logThread 1 redo log links: forward: 3 backward: 1siz: 0x19000 seq: 0x0000000b hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 2Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0196Low scn: 0x0000.000b019a 04/27/2011 22:52:10Next scn: 0xffff.ffffffff 01/01/1988 00:00:00 LOG FILE #3:(name #1) /flashcard/oradata/G10R2/onlinelog/o1_mf_3_6v34jpmp_.log(name #2) /s01/flash_recovery_area/G10R2/onlinelog/o1_mf_3_6v34jpyn_.logThread 1 redo log links: forward: 0 backward: 2siz: 0x19000 seq: 0x00000009 hws: 0x2 bsz: 512 nab: 0x2 flg: 0x1 dup: 2Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0190Low scn: 0x0000.000b0193 04/27/2011 22:52:04Next scn: 0x0000.000b0196 04/27/2011 22:52:05 記以錄之！

轉(zhuǎn)載于:https://www.cnblogs.com/macleanoracle/archive/2013/03/19/2967745.html

總結(jié)

以上是生活随笔為你收集整理的Oracle内部错误:ORA-00600[2608]一例的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。