Your database is open and running in ARCHIVELOG mode.
You take RMAN full backups every Sunday night.
On Monday morning, while querying the user1.emoloyees table, you receive the following error
message:
01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5:
‘/u01/app/oracle/oradata/orcl/exanple0l.dbf*
You need to recover from this while ensuring that:
1. The data file remains online.
2. Mean Time To Recover (MTTR) is minimized as much as possible
You have no backup control file, but all the archived logs are accessible. Which method will best
satisfy the requirements?
A.
flash back the corrupted blocks
B.
use the DBMS_REPAIR package
C.
use RMAN tablespace point in time recovery
D.
use the RMAN BLCCKRECOVER command
E.
perform a table point in time recovery with datapump export and import