Re: block corruption

2008/11/24 Howard Latham <howard.latham_at_gmail.com>

>
>
> for clarity THIS is what I am running
>
> SET SERVEROUTPUT ON
> DECLARE num_corrupt INT;
> BEGIN
> num_corrupt := 0;
> DBMS_REPAIR.CHECK_OBJECT (
> SCHEMA_NAME => 'SCOTT',
> OBJECT_NAME => 'DEPT',
>
> REPAIR_TABLE_NAME => 'REPAIR_TABLE',
> CORRUPT_COUNT => num_corrupt);
> DBMS_OUTPUT.PUT_LINE('number corrupt: ' || TO_CHAR (num_corrupt));
> END;
> /
>
>

Hi:

If you're in archive log mode use rman to repair exclusively these corrupted blocks

http://sysdba.wordpress.com/2006/04/05/how-to-check-for-and-repair-block-corruption-with-rman-in-oracle-9i-and-oracle-10g/

Regards

D.

--
http://www.freelists.org/webpage/oracle-l