Re: block corruption
- From: "David Ballester" <ballester.david@xxxxxxxxx>
- To: howard.latham@xxxxxxxxx
- Date: Mon, 24 Nov 2008 16:03:15 +0100
2008/11/24 Howard Latham <howard.latham@xxxxxxxxx>
>
>
> 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.
Other related posts: