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

[Former Member]

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

[Former Member]

Hi All,

In a case like this the first thing to check is table spaces , just check all datafiles are having the status online

Log in to SQLPLUS and issue "select file#,name,status from v$datafile;" check all datafiles are having the status online if any of them having the status "recover" then you have to recover the data file with oracle archive available

recover datafile file#;

After that issue

alter database datafile file# online;

then try to shtdown and restart the database;

Shanaka.