Re: block corruption
- From: "Howard Latham" <howard.latham@xxxxxxxxx>
- To: "David Ballester" <ballester.david@xxxxxxxxx>
- Date: Mon, 24 Nov 2008 15:41:21 +0000
This very old data not backed up but also not needed. Table is about
60gig so I dont want to have to do an export or a create table as
select but cannot get repair to work
On 24/11/2008, David Ballester <ballester.david@xxxxxxxxx> wrote:
> 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.
>
--
Howard A. Latham
--
//www.freelists.org/webpage/oracle-l
Other related posts:
