OCP CBT Question 645
Please solve the following question.
You detect a few corrupted blocks in data file `/u01/app/oracle/oradata/ORCL/users01.dbf` (file #4) as indicated by `DB_BLOCK_CORRUPTION` errors in `V$DATABASE_BLOCK_CORRUPTION`. The database is in ARCHIVELOG mode and open. Which RMAN command is suitable for repairing only the corrupted blocks without taking the entire data file offline?
Output from V$DATABASE_BLOCK_CORRUPTION shows:
OWNER FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTION_TYPE
--------- -------- -------- ------ ------------------ ----------------
SYS 4 123 1 123456789 PHYSICAL