OCP CBT Question 510
Please solve the following question.
A user reports that they are receiving ORA-01578 errors when querying a specific block in the EMPLOYEES table within the USERS tablespace. You have identified the corrupt block using DB_VERIFY and confirmed that only this block is affected. You have a recent RMAN backup that includes the affected datafile and all necessary archived redo logs.Examine the RMAN commands. Which set of commands will most efficiently recover the corrupt block without affecting other database operations?
sql-- Example output from DB_VERIFY or V$DATABASE_BLOCK_CORRUPTION-- File# Block# Blocks Corrupt_Description-- ----- ------ ------ ---------------------- 4 12345 1 Corrupt block