Oracle Database Discussions

hi

I had the foll. scenario:-

Initially got the foll.issue reported:-

[code]

ORA-01578: ORACLE data block corrupted (file # 4, block # 115278)

ORA-01110: data file 4: 'C:\ORACLE\ORADATA\GIRO\GIRO_1.DBF'

ORA-06512: at line 35

Things done:-

select owner, segment_type, segment_name from dba_extents

where file_id = 4 and 115278 between block_id and block_id+blocks-1;

OWNER                          SEGMENT_TYPE
------------------------------ ------------------
SEGMENT_NAME
--------------------------------------------------------------------------------

GEOROUTE                       INDEX
KSYSHASTUS_DEMLOC

SQL>SELECT owner, constraint_name, constraint_type, table_name
    FROM dba_constraints
   WHERE owner='GEOROUTE'
     AND constraint_name='KSYSHASTUS_DEMLOC';

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
GEOROUTE                       KSYSHASTUS_DEMLOC              P
HASTUS_DEMLOC

=======================================

This is fixed by dropping and recreating index&constraint

And after this when querying:-

select owner, segment_type, segment_name from dba_extents
where file_id = 4 and 115278 between block_id and block_id+blocks-1;

no rows selected

[/code]

So far, good.

=======================================================

But , the below query still showing that 2 blocks are corrupted.

select * from v$database_block_corruption;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO

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

         4     115278          1                  0 FRACTURED

         4     112670          1                  0 CORRUPT

So my question is, how can I remove this corruption altogether now, eventhough no objects are being affected at the moment

(to prevent new objects being affected by corruption?)

thanks&Regards..