Skip to Content
0
Former Member
Jan 16, 2008 at 02:54 PM

Coruupted Blocks in BW - real or cosmetic?

92 Views

In SAP Note 849485 there is this statement:

"Note that DBV can still return DBV-00200 messages after a restructuring of all indexes. If a block that has been marked as corrupt is returned to the freespace area by dropping an index, and then allocated by another index as part of an extent, the "corruption" remains until data is written to the

block. This is entirely a cosmetic problem with DBV."

If DB13-DBVerify show a corrupted block"

dbv file=/oracle/DWP/sapdata17/dwp_119/dwp.data119 blocksize=8192

DBV-00200: Block, dba 617370019, already marked corrupted

I then run this select statement and it shows there is no object there?

SELECT SEGMENT_NAME, SEGMENT_TYPE, OWNER FROM SYS.DBA_EXTENTS WHERE FILE_ID = 147 AND 617370019 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;

no rows selected

How can I tell if a corrupted block is real or cosmetic in my BW system?

And if they are cosmetic, how can I get rid of these errors in DB13-DBVerify?