Re: corrupt block

Ralf Zwanziger wrote:
>
> Hi,
> we've got an entry in the alertXXX.log file every day, saying:
>
> ***
> Corrupt block relative dba: 0x06400c09 (file 25, block 3081)
> Bad header found during buffer read
> Data in bad block -
> type: 16 format: 2 rdba: 0x06001609
> last change scn: 0x0000.0b32fdb4 seq: 0x1 flg: 0x00
> consistency value in tail: 0xfdb41001
> check value in block header: 0x0, block checksum disabled
> spare1: 0x0, spare2: 0x0, spare3: 0x0
> ***
>
> Is there a way to find out more information on corrupt datafiles?
> Is it possible to repair the datafile?
>
> Bye,
> Ralf

sqlplus> desc dbms_repair

or read the package docs in

D:\Oracle\Ora81\rdbms\admin\dbmsrpr.sql

CREATE OR REPLACE PACKAGE dbms_repair   

  IS

• OVERVIEW --
• The DBMS_REPAIR package consists of data corruption repair procedures --
• SECURITY --
• The package is owned by SYS.
• Execution privilege is not granted to other users.

  ---

  procedure fix_corrupt_blocks(
    schema_name IN varchar2,
    object_name IN varchar2,
    partition_name IN varchar2 DEFAULT NULL,     object_type IN binary_integer DEFAULT TABLE_OBJECT,     repair_table_name IN varchar2 DEFAULT 'REPAIR_TABLE',     flags IN binary_integer DEFAULT NULL,     fix_count OUT binary_integer); Received on Tue Jun 12 2001 - 01:36:51 CDT