This discussion is locked
5 Replies Latest reply: Jun 19, 2013 10:30 PM by Jeisson Leonel RSS

ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

sreekar tandaboina
Currently Being Moderated

Hi,

 

I got block corrupt on development server(Test system also on same area),i got this error in checkDB and verifyDB

 

VerifyDB:

 

BR0278W Command output of 'D:\oracle\DCE\102\BIN\dbv file=I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4 blocksize=8192

DBVERIFY: Release 10.2.0.4.0 - Production on Sat Mar 20 13:14:07 2010

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

DBVERIFY - Verification starting : FILE = I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4

Block Checking: DBA = 21204988, Block Type = KTB-managed data block

data header at 0x2c8625c

kdbchk: row locked by non-existent transaction

        table=0   slot=37

        lockid=82   ktbbhitc=2

Page 233468 failed with check code 6101

DBVERIFY - Verification complete

Total Pages Examined         : 258560

Total Pages Processed (Data) : 46893

Total Pages Failing   (Data) : 1

Total Pages Processed (Index): 47654

Total Pages Failing   (Index): 0

Total Pages Processed (Other): 20247

Total Pages Processed (Seg)  : 0

Total Pages Failing   (Seg)  : 0

Total Pages Empty            : 143766

Total Pages Marked Corrupt   : 0

Total Pages Influx           : 0

Highest block SCN            : 1251807644 (0.1251807644)

BR0398E DBVERIFY has detected corrupt blocks in I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4

 

 

checkDB:

ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 834150, time: 2010-03-18 16.47.26, me

ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []

 

 

kindly help

 

Regards

Sreekar

Actions