5 Replies Latest reply: Nov 29, 2012 1:30 PM by mseberg RSS

    RMAN backup got failed with the error ORA-19566


      One of database, while taking backup using RMAN, it failed with the following error:

      RMAN-03009: failure of backup command on DISK4 channel at 11/28/2012 09:47:29
      ORA-19566: exceeded limit of 0 corrupt blocks for file <faile_name>

      I used DBV to identify the number of blocks corrupted.

      I referred the Metalink iD 457422.1 & 336133.1. But it did not help since the corrupted blocks have got object in it.

      I could able to find the object as well. it is one of the table in the datafile.

      I used 'ALTER TABLE ... MOVE..' command to see if that helps. But again getting the same error while taking the backup and corrupted blocks still exists.

      DB Version :
      OS Version : RHEL 5.6

      Please help me out to get this fixed.