[Oracle] uses the rman blockrecover command and ledba21rman
You work as a database administrator at Certkiller. com. Your database is open and running in ARCHIVELOG mode.
You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.employees table,
You receive the following error message:
01578: ORACLE data block upted (file #5, block #51) ORA-01110: data file 5: '/u01/app/oracle/oradata/orcl/example01.dbf'
You need to rectify the uption while ensuring the following:
The data file shocould remain online. The mean time to recover (MTTR) shocould be minimal. You are not using a backup control file and all
Archived logs are accessible. Which option wowould you choose?
A. flash back the upted blocks
B. use the DBMS_REPAIR package
C. use the rman tspitr command
D. use the rman blockrecover command
E. use the restore database and recover database commands
F. investigate the time at which the specified uption occurred and perform a point-in-time recovery
Answer: D
In archive mode, the database performs a full backup every Sunday. When data blocks are found to be damaged on Monday morning, MTTR is required for the least time and data file is required to be online. Therefore, the best method is RMANBLOCKRECOVER.