OCP CBT Question 516

Please solve the following question.

You are administering an Oracle Database 19c. A user reports encountering `ORA-01578: ORACLE data block corrupted (file # 5, block # 12345)` when querying the `EMPLOYEES` table. You have a full RMAN backup taken last night and archived redo logs since then. Which is the most appropriate RMAN command to perform block recovery while minimizing downtime for other users?

sqlSELECT /*+ PARALLEL */ employee_id, first_name FROM employees WHERE employee_id = 100;-- Above query fails with ORA-01578 for file # 5, block # 12345.-- Data file #5 belongs to the USERS tablespace.

RMAN> RESTORE DATAFILE 5; RECOVER DATAFILE 5;

RMAN> REPAIR BLOCK 12345 DATAFILE 5;

RMAN> BLOCKRECOVER DATAFILE 5 BLOCK 12345;

RMAN> RESTORE TABLESPACE USERS; RECOVER TABLESPACE USERS;