4 Replies Latest reply: Jan 28, 2013 3:54 AM by sandy121 RSS

    Needs help regarding block corruption

    sandy121
      DB Version - 11.2.0.3.0
      Issue - Last backup failed due to block corruption ,message says "ORA-19566: exceeded limit of 0 corrupt blocks for file /GP/GAA01-N-P/db00/index01/GPEDWPR/bi_gpedw_fcct.dbf'

      I tried to perform block recovery using RMAN but it was not present in backup, hence failed. tried in the below way also :-

      RMAN> LIST FAILURE
      2> ;

      using target database control file instead of recovery catalog
      List of Database Failures
      =========================

      Failure ID Priority Status Time Detected Summary
      ---------- -------- --------- ------------- -------
      72981 HIGH OPEN 13-JAN-13 Datafile 58: '/GP/GAA01-N-P/db00/index01/GPEDWPR/bi_gpedw_fcct.dbf'
      contains one or more corrupt blocks


      RMAN> ADVISE FAILURE
      2> ;

      List of Database Failures
      =========================

      Failure ID Priority Status Time Detected Summary
      ---------- -------- --------- ------------- -------
      72981 HIGH OPEN 13-JAN-13 Datafile 58: '/GP/GAA01-N-P/db00/index01/GPEDWPR/bi_gpedw_fcct..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=2055 device type=DISK
      analyzing automatic repair options complete

      Mandatory Manual Actions
      ========================
      1. No backup of block 3106752 in file 58 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption
      2. No backup of block 3106911 in file 58 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption
      3. No backup of block 3106976 in file 58 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption
      4. No backup of block 3107504 in file 58 was found. Drop and re-create the associated object (if possible), or use the DBMS_REPAIR package to repair the block corruption
      5. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair

      Now how to troubleshoot ? Any help will be highly appreciated