Re: block corruption
From: David Ballester <ballester.david_at_gmail.com>
Date: Mon, 24 Nov 2008 16:03:15 +0100
Message-ID: <6a29f8b0811240703i5ac784c8le4b89ce5cf76612a@mail.gmail.com>
Date: Mon, 24 Nov 2008 16:03:15 +0100
Message-ID: <6a29f8b0811240703i5ac784c8le4b89ce5cf76612a@mail.gmail.com>
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
Regards
D.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 24 2008 - 09:03:15 CST