Saturday , December 9 2023

RMAN ORA-19566 exceeded limit

When we get a backup with Rman, if there is a damaged block on a datafile, the ORA-19566 error will be received and the backup operation will not be completed. It will generate error message as below.

ORA-19566: exceeded limit of 0 corrupt blocks for file +DATA/orcl/datafile/users.369.864669603

First, the corrupt block should be corrected. You can use the following article.

How To Detect and Repair Block Corruption in Oracle

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.

For more than one datafile the maxcorrupt can be set with one command as follows.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *