Step1. check corrupted block file# and block#
SQL> SELECT * FROM V$DATABASE_BLOCK_CORRUPTION;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
———- ———- ———- —————— ———
1 507 1 0 CORRUPT
Step2. recover corrupted block and then validate again
rman target /
blockrecover datafile 1 block 507;
–To recover many blocks, using
BLOCKRECOVER DATAFILE 2 [...]
Filed under: Backup and Recovery | Leave a Comment »
