corrupt datablocks

Posted by Roshan on Mar 15, 2018; 8:06am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/corrupt-datablocks-tp5391.html

Oracle Database 12.1.0.2.0

 

Hi,

 

I am getting a datafile block corruption error for datafile 2

 

RMAN> list failure

2> ;

 

 

using target database control file instead of recovery catalog

Database Role: PRIMARY

 

 

List of Database Failures

=========================

 

 

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

21922      HIGH     OPEN      30-OCT-17     Datafile 2: '/u01/oradata/DLP/datafile/LOB02.dbf' contains one or more corrupt blocks

 

RMAN> advise failure;

 

 

Database Role: PRIMARY

 

 

List of Database Failures

=========================

 

 

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

21922      HIGH     OPEN      30-OCT-17     Datafile 2: '/u01/oradata/DLP/datafile/LOB02.dbf' contains one or more corrupt blocks

 

 

analyzing automatic repair options; this may take some time

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=7 device type=DISK

analyzing automatic repair options complete

 

 

Mandatory Manual Actions

========================

1. No backup of block 4500 in file 2 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption

2. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair

 

 

Optional Manual Actions

=======================

no manual actions available

 

 

Automated Repair Options

========================

no automatic repair options available

Can you please guide me with the recovery of the table?

how do I find the table name?

 

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO     CON_ID

---------- ---------- ---------- ------------------ --------- ----------

         2       4500          1                  0 FRACTURED          0

 

 

 

 

SEGMENT_TYPE       SEGMENT_NAME                

------------------ ------------------------------

TABLE              L7STATISTICS

 

BEGIN

  DBMS_REPAIR.admin_tables (

  table_name => ' ',

  table_type =>' ',

  action => DBMS_REPAIR.create_action,

  tablespace => 'LOB_TABLESPACE');

 

Thanks,

Roshan