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