Oracle内部エラ:ORA-00600[2608]一例

プロのOracle Databaseの復旧サービスを提供
携帯番号: +86 13764045638 メール:service@parnassusdata.com

 

ある10.2.0.4単ノートデータベースがデータファイルをリカバリするときにORA-00600: internal error code, arguments: [2608], [1], [0], [690423], [0], [690425], [], []内部エラになって、そのログは以下の通り:

 

 

 

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]の原因はデータファイルヘッダに記録されたcheckpoint scnが小さすぎたからだ。Oracleはそのcheckpoint scnとブロックのresetlogs scn及びログファイルのLow scnと比べる。もしファイルヘッダのcheckpoint scnが小さすぎた場合に、ORA-00600[2608]内部エラになる。

つぎはデータファイルヘッダのkcvfhckp構造に記録されたcheckpoint scnを小さい数値に変更することで、ORA-00600[2608]エラの場合を作成する:

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=1

tablespace 12, index=12 krfil=11 prev_file=0

unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

Checkpoint cnt:4 scn: 0x0000.000b01c2 04/27/2011 22:52:31

Stop scn: 0x0000.000b01c5 04/27/2011 22:52:39

Creation Checkpointed at scn:  0x0000.000b01a8 04/27/2011 22:52:24

thread:1 rba:(0xb.e.10)

…………………………………………….

Hot Backup end marker scn: 0x0000.00000000

aux_file is NOT DEFINED

V10 STYLE FILE HEADER:

Compatibility Vsn = 169870080=0xa200300

Db ID=2894437650=0xac859d12, Db Name=’G10R2′

Activation ID=0=0x0

Control Seq=740=0x2e4, File size=6400=0x1900

File 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:0

reset logs count:0x2cade887 scn: 0x0000.000a88f9 reset logs terminal rcv data:0x0 scn: 0x0000.00000000

prev reset logs count:0x2cadd4e7 scn: 0x0000.000a7f86 prev reset logs terminal rcv data:0x0 scn: 0x0000.00000000

recovered at 01/01/1988 00:00:00

status: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号データファイルヘッダのCheckpoint scnは0x0000.000b01c2 だが、resetlogs scnは0x0000.000a88f9 である。                                       */

 

/* Checkpoint scnを0x0000.000a88f7 に変更する                    */

 

[oracle@rh2 u01]$ bbed filename=data02.dbf blocksize=8192 password=blockedit mode=edit

 

BBED: Release 2.0.0.0.0 – Limited Production on Wed Apr 27 22:55:30 2011

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

************* !!! For Oracle Internal Use only !!! ***************

BBED> set blocksize 8192

BLOCKSIZE       8192

 

BBED> set block 2

BLOCK#          2

 

BBED> map

File: data02.dbf (0)

Block: 2                                     Dba:0x00000000

————————————————————

Data File Header

 

struct kcvfh, 676 bytes                    @0

 

ub4 tailchk                                @8188

 

BBED> p kcvfh

struct kcvfh, 676 bytes                     @0

struct kcvfhbfh, 20 bytes                @0

ub1 type_kcbh                         @0        0x0b

ub1 frmt_kcbh                         @1        0xa2

ub1 spare1_kcbh                       @2        0x00

ub1 spare2_kcbh                       @3        0x00

ub4 rdba_kcbh                         @4        0x02c00001

ub4 bas_kcbh                          @8        0x00000000

ub2 wrp_kcbh                          @12       0x0000

ub1 seq_kcbh                          @14       0x01

ub1 flg_kcbh                          @15       0x04 (KCBHFCKV)

ub2 chkval_kcbh                       @16       0xb4a1

ub2 spare3_kcbh                       @18       0x0000

struct kcvfhhdr, 76 bytes                @20

ub4 kccfhswv                          @20       0x00000000

ub4 kccfhcvn                          @24       0x0a200300

ub4 kccfhdbi                          @28       0xac859d12

text kccfhdbn[0]                      @32      G

text kccfhdbn[1]                      @33      1

text kccfhdbn[2]                      @34      0

text kccfhdbn[3]                      @35      R

text kccfhdbn[4]                      @36      2

text kccfhdbn[5]                      @37

text kccfhdbn[6]                      @38

text kccfhdbn[7]                      @39

ub4 kccfhcsq                          @40       0x000002e4

ub4 kccfhfsz                          @44       0x00001900

s_blkz kccfhbsz                       @48       0x00

ub2 kccfhfno                          @52       0x000b

ub2 kccfhtyp                          @54       0x0003

ub4 kccfhacid                         @56       0x00000000

ub4 kccfhcks                          @60       0x00000000

text 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       0x00000000

struct kcvfhcrs, 8 bytes                 @100

ub4 kscnbas                           @100      0x000b01a8

ub2 kscnwrp                           @104      0x0000

ub4 kcvfhcrt                             @108      0x2cae0628

ub4 kcvfhrlc                             @112      0x2cade887

struct kcvfhrls, 8 bytes                 @116                             resetlogs scn

ub4 kscnbas                           @116      0x000a88f9

ub2 kscnwrp                           @120      0x0000

ub4 kcvfhbti                             @124      0x00000000

struct kcvfhbsc, 8 bytes                 @128

ub4 kscnbas                           @128      0x00000000

ub2 kscnwrp                           @132      0x0000

ub2 kcvfhbth                             @136      0x0000

ub2 kcvfhsta                             @138      0x0004 (KCVFHOFZ)

struct kcvfhckp, 36 bytes                @484

struct kcvcpscn, 8 bytes              @484                               checkpoint scn

ub4 kscnbas                        @484      0x000b01c2

ub2 kscnwrp                        @488      0x0000

ub4 kcvcptim                          @492      0x2cae062f

ub2 kcvcpthr                          @496      0x0001

union u, 12 bytes                     @500

struct kcvcprba, 12 bytes          @500

ub4 kcrbaseq                    @500      0x0000000b

ub4 kcrbabno                    @504      0x0000001b

ub2 kcrbabof                    @508      0x0010

ub1 kcvcpetb[0]                       @512      0x02

ub1 kcvcpetb[1]                       @513      0x00

ub1 kcvcpetb[2]                       @514      0x00

ub1 kcvcpetb[3]                       @515      0x00

ub1 kcvcpetb[4]                       @516      0x00

ub1 kcvcpetb[5]                       @517      0x00

ub1 kcvcpetb[6]                       @518      0x00

ub1 kcvcpetb[7]                       @519      0x00

ub4 kcvfhcpc                             @140      0x00000004

ub4 kcvfhrts                             @144      0x00000000

ub4 kcvfhccc                             @148      0x00000003

struct kcvfhbcp, 36 bytes                @152

struct kcvcpscn, 8 bytes              @152

ub4 kscnbas                        @152      0x00000000

ub2 kscnwrp                        @156      0x0000

ub4 kcvcptim                          @160      0x00000000

ub2 kcvcpthr                          @164      0x0000

union u, 12 bytes                     @168

struct kcvcprba, 12 bytes          @168

ub4 kcrbaseq                    @168      0x00000000

ub4 kcrbabno                    @172      0x00000000

ub2 kcrbabof                    @176      0x0000

ub1 kcvcpetb[0]                       @180      0x00

ub1 kcvcpetb[1]                       @181      0x00

ub1 kcvcpetb[2]                       @182      0x00

ub1 kcvcpetb[3]                       @183      0x00

ub1 kcvcpetb[4]                       @184      0x00

ub1 kcvcpetb[5]                       @185      0x00

ub1 kcvcpetb[6]                       @186      0x00

ub1 kcvcpetb[7]                       @187      0x00

ub4 kcvfhbhz                             @312      0x00000000

struct kcvfhxcd, 16 bytes                @316

ub4 space_kcvmxcd[0]                  @316      0x00000000

ub4 space_kcvmxcd[1]                  @320      0x00000000

ub4 space_kcvmxcd[2]                  @324      0x00000000

ub4 space_kcvmxcd[3]                  @328      0x00000000

word kcvfhtsn                            @332      12

ub2 kcvfhtln                             @336      0x0006

text kcvfhtnm[0]                         @338     D

text kcvfhtnm[1]                         @339     A

text kcvfhtnm[2]                         @340     T

text kcvfhtnm[3]                         @341     A

text kcvfhtnm[4]                         @342     0

text kcvfhtnm[5]                         @343     2

text 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      0x0000000b

struct kcvfhrfs, 8 bytes                 @372

ub4 kscnbas                           @372      0x00000000

ub2 kscnwrp                           @376      0x0000

ub4 kcvfhrft                             @380      0x00000000

struct kcvfhafs, 8 bytes                 @384

ub4 kscnbas                           @384      0x00000000

ub2 kscnwrp                           @388      0x0000

ub4 kcvfhbbc                             @392      0x00000000

ub4 kcvfhncb                             @396      0x00000000

ub4 kcvfhmcb                             @400      0x00000000

ub4 kcvfhlcb                             @404      0x00000000

ub4 kcvfhbcs                             @408      0x00000000

ub2 kcvfhofb                             @412      0x0000

ub2 kcvfhnfb                             @414      0x0000

ub4 kcvfhprc                             @416      0x2cadd4e7

struct kcvfhprs, 8 bytes                 @420

ub4 kscnbas                           @420      0x000a7f86

ub2 kscnwrp                           @424      0x0000

struct kcvfhprfs, 8 bytes                @428

ub4 kscnbas                           @428      0x00000000

ub2 kscnwrp                           @432      0x0000

ub4 kcvfhtrt                             @444      0x00000000

 

BBED> set offset 484

OFFSET          484

 

BBED> p

pad

ub1 pad                                     @484      0xc2

 

BBED> modify /x f788

Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y

File: 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 486

OFFSET          486

 

BBED> p

pad

ub1 pad                                     @486      0x00

 

BBED> modify /x 0x0a00

File: 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      0x000a88f7

ub2 kscnwrp                           @488      0x0000

ub4 kcvcptim                             @492      0x2cae062f

ub2 kcvcpthr                             @496      0x0001

union u, 12 bytes                        @500

struct kcvcprba, 12 bytes             @500

ub4 kcrbaseq                       @500      0x0000000b

ub4 kcrbabno                       @504      0x0000001b

ub2 kcrbabof                       @508      0x0010

ub1 kcvcpetb[0]                          @512      0x02

ub1 kcvcpetb[1]                          @513      0x00

ub1 kcvcpetb[2]                          @514      0x00

ub1 kcvcpetb[3]                          @515      0x00

ub1 kcvcpetb[4]                          @516      0x00

ub1 kcvcpetb[5]                          @517      0x00

ub1 kcvcpetb[6]                          @518      0x00

ub1 kcvcpetb[7]                          @519      0x00

 

BBED> sum

Check value for File 0, Block 2:

current = 0xb4a1, required = 0x3d95

 

BBED> sum apply

Check value for File 0, Block 2:

current = 0x3d95, required = 0x3d95

 

/* 如我们所期待地出现了ORA-00600[2608]内部错误 */

 

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進数の0x000a88f7で、つまり前に修正したcheckpoint scn。

721306等は0xb019aで、今のログファイルの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_.log

Thread 1 redo log links: forward: 2 backward: 0

siz: 0x19000 seq: 0x0000000a hws: 0x2 bsz: 512 nab: 0x2 flg: 0x1 dup: 2

Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0193

Low scn: 0x0000.000b0196 04/27/2011 22:52:05

Next 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_.log

Thread 1 redo log links: forward: 3 backward: 1

siz: 0x19000 seq: 0x0000000b hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 2

Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0196

Low scn: 0x0000.000b019a 04/27/2011 22:52:10

Next 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_.log

Thread 1 redo log links: forward: 0 backward: 2

siz: 0x19000 seq: 0x00000009 hws: 0x2 bsz: 512 nab: 0x2 flg: 0x1 dup: 2

Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0190

Low scn: 0x0000.000b0193 04/27/2011 22:52:04

Next scn: 0x0000.000b0196 04/27/2011 22:52:05

 

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪ICP备14014813号

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569