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]

This message was moderated.

[former_member207463]

Please check SAP Note 1868324 about Handling ORA-600/ORA-7445 error.

Check also notes:

23345

Consistency check of ORACLE database

365481

Block corruptions

Best regards,

Jeisson Leonel

[former_member206552]

Hi Sreekar

another option is to use rman to verify files

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup005.htm

Using RMAN to Validate Database Files

Best Regards

Marius

[Former Member]

hi sreekar,

Run this command as your orasid user oradce user dbv file=I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4 in the command line.

This will display if it is a false alert or actually corrupt.

Regards,

Johan

[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.

[stefan_koehler]

Hello Sreekar,

check this thread:

Any steps to solve this issue is described in there.

Maybe the reason for this corruption is oracle bug #7329252, which is described in sapnote #1413928.

Regards

Stefan