RMAN ORA-19566 exceeded limit
When taking RMAN backup the corrupted block will make the backup fail. If the corrupted block does not interfere with the functioning of the database, but it causes problems with the backup, the MAXCORRUPT value can be set as follows, and the backup operation can be completed successfully.
In our backup script, we set the maxcorrupt value for the corresponding datafile up to the number of corrupted blocks.
RMAN> RUN{
SET MAXCORRUPT FOR DATAFILE 352 to 1;
BACKUP DATABASE;
}
For more than one datafile
RMAN> RUN{
SET MAXCORRUPT FOR DATAFILE 353,353 to 1;
BACKUP DATABASE;
}
Post a Comment
Post a Comment