Skip to Content
0
Former Member
Feb 27, 2009 at 04:39 PM

"Corrupted blocks" but result of SELECT to identify is "no rows selected" ?

322 Views

Hello,

the DBVERIFY detected a corrupted block:

BR0395I Verifying /oracle/P12/sapdata1/stabi_4/stabi.data4 using DBVERIFY...

BR0278W Command output of '/oracle/P12/102_64/bin/dbv file=/oracle/P12/sapdata1/stabi_4/stabi.data4 blocksize=8192':

DBVERIFY: Release 10.2.0.2.0 - Production on Sun Feb 22 13:31:16 2009

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

DBVERIFY - Verification starting : FILE = /oracle/P12/sapdata1/stabi_4/stabi.data4

Page 199976 is marked corrupt

Corrupt block relative dba: 0x22830d28 (file 138, block 199976)

Bad check value found during dbv:

Data in bad block:

type: 6 format: 2 rdba: 0x22830d28

last change scn: 0x0000.9dd73bd3 seq: 0x1 flg: 0x06

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0x3bd30601

check value in block header: 0xb23a

computed block checksum: 0x393c

DBVERIFY - Verification complete

Total Pages Examined : 1048576

Total Pages Processed (Data) : 0

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 600019

Total Pages Failing (Index): 0

Total Pages Processed (Other): 2801

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 445755

Total Pages Marked Corrupt : 1

Total Pages Influx : 0

Highest block SCN : 2768048657 (0.2768048657)

BR0398E DBVERIFY detected corrupted blocks in /oracle/P12/sapdata1/stabi_4/stabi.data4

BR0280I BRBACKUP time stamp: 2009-02-22 13.35.04

BR0063I 137 of 151 files processed - 984573.070 MB of 1067157.180 MB done

BR0204I Percentage done: 92.26%, estimated end time: 14:28

When I try to identify if a table or an index is affected I get the follofwing result:

SQL> SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE

2 FROM DBA_EXTENTS WHERE FILE_ID = 138 AND 199976

3 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS -1;

no rows selected

SQL>

Is there anyone who can tell me how I can fix this problem ?

Thanks and Best regards

Carsten