ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-011

043-011

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-04 10:44:56 0 删除 编辑
11. You work as a database administrator at Certkiller .com. Your dat
abase is open and running in ARCHIVELOG mode. You take RMAN full bac
kups 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) s
hould 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 perf
orm a point-in-time recovery
Answer: D
数据库在归档模式下,每个星期天进行一次全备份,星期一早晨发现数据块损
坏,要求MTTR 时间最少,要求data file 在线,所以最好的方法就是RMAN
BLOCKRECOVER

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717626/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-010
下一篇: 043-012
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214084