What is the cause and solution for ORA-19566: exceeded limit of 0 corrupt blocks for file .. error?
Ezana Answered question 20/12/2022
Cause: Corrupted data blocks
When a BACKUP, VALIDATE, or BACKUP VALIDATE command is run using RMAN, it automatically detects corrupted blocks and throws ‘ORA-19566 ‘ error message.
Solution: You can instruct RMAN to recover all blocks reported in V$DATABASE_BLOCK_CORRUPTION.
RMAN> recover corruption list;
And another way to recover the block is to specify the data file and block number:
Example:
RMAN> recover datafile 4 block 10;
Ezana Answered question 20/12/2022