ITPub博客

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

043-100

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-07 21:41:42 0 删除 编辑
100. You database operates in ARCHIVELOG mode and user-managed consis
tent backups are performed every Sunday
night. On Tuesday, at 9:00 a.m. the current log sequence number was
369. Also, on Tuesday you lost the data file belonging to the SYSTEM
tablespace and an achivelog file (sequence number 356) that contained
redo entries between 8:00 a.m. and 8.30 a.m.
With reference to this scenario, what would you do to recover the dat
abase?
A. Restore all the data files from last Sunday's backup, and then per
form. a time-based recovery.
B. Restore all the data files from last Sunday's backup, and then per
form. a cancel-based recovery.
C. Restore all the data files from last Sunday's backup, and then per
form. a change-based recovery.
D. Restore only data files that belong to the SYSTEM tablespace from
last Sunday's backup, and then perform. a complete recovery.
Answer: B
丢失的归档文件,只能用基于cancel 的恢复

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203413