This discussion is archived
5 Replies Latest reply: Nov 29, 2012 11:30 AM by mseberg RSS

RMAN backup got failed with the error ORA-19566

977068 Newbie
Currently Being Moderated
Hi,

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 : 10.2.0.5
OS Version : RHEL 5.6

Please help me out to get this fixed.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points