【oracle】oracledba21 use the RMAN BLOCKRECOVER command
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 corrupted (file # 5, block # 51) ORA-01110: data file 5: ‘/u01/app/oracle/oradata/orcl/example01.dbf‘
You need to rectify the corruption while ensuring the following:
The data file should remain online. The mean time to recover (MTTR) should be minimal. You are not using a backup control file and all the
archived logs are accessible. Which option would you choose?
A. flash back the corrupted 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 corruption occurred and perform a point-in-time recovery
Answer: D
数据库在归档模式下，每个星期天进行一次全备份，星期一早晨发现数据块损坏，要求 MTTR 时间最少，要求 data file 在线，所以最好的方法就是 RMANBLOCKRECOVER
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
