FRACTURED block

[ganimede_dignan]

Hi,

I've find a fractured block in my Oracle database:

SQL> select * from V$DATABASE_BLOCK_CORRUPTION;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO

---------- ---------- ---------- ------------------ ---------

        50     379385          1                  0 FRACTURED

I've find that was a Z table on this block.. a table with several deleted recods, so I export/import this table. Now:

SQL> select * from dba_extents where block_id=379385 and file_id=50;

no rows selected

So, how can I mark it as "unusable" block?

Thank you,

[JamesZ]

Hi Ganimede,

You should use following command to check the extent:

select segment_name, partition_name, segment_type, block_id, blocks

from dba_extents

where (<corrupted block> between

      block_id and (block_id + blocks - 1))

and file_id = <Filenummer from the first statement> and rownum < 2;

SAP note 365481 is very helpful here.

Best regards,
James

[manish_singh13]

Hello,

Please refer below SAP Notes related to corrupted block/s:

365481 - Block corruptions

540463 - FAQ: Consistency Checks + Block Corruptions

Thanks,

Manish