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

[Former Member]

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

[lbreddemann]

>

> 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 ?

This is called a 'freespace corruption'. And it's not a problem!

You don't have to do anything about it, since the block will be reformatted when it should be used.

Anyhow if you want to get rid of this block, the safest way (besides recovering a good backup of the block) is to reorganize the complete tablespace.

There are also SAP notes on this topic - but right now I'm too lazy to look them up for you. So search yourself for "corruption"+"freespace" and I'm sure you'll find the right ones.

regards,

Lars

[Former Member]

Hi Lars,

thanks a lot !

It´s the SAP-Note 354293 - DBVerify meldet korrupten Block im Freiplatzbereich

I have executed the 2nd solution and it works fine

Best Regards

Carsten