ITPub博客

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

043-158

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-10 09:29:39 0 删除 编辑
158. Every Sunday, consistent backups are performed on your database.
Because of a user error, you performed an incomplete recovery on Tue
sday and opened the database with the RESETLOGS option. A user error
occurs again on Thursday, which necessitates an incomplete recovery.
Sunday's backup is the most recent backup available. What would you d
o in this scenario?
A. recovery cannot be performed because a backup was not performed af
ter the last incomplete recovery
B. restore all the files from Sunday's backup, and then recover up to
the point in time when the RESETLOGS operation was performed on Tues
day
C. restore all the files from Sunday's backup, and open the database
to reset the database to the point in time when the backup was perfor
med on Sunday
D. restore all the files from Sunday's backup, and then perform. an in
complete recovery up to the point in time when the user error occurre
d on Thursday
Answer: D
10g RESETLOGS 打开后可以再次应用其之前的日志
10g 支持穿越resetlog 用当前数据库的控制文件(resetlog 后的控制文件)
加上resetlog 之前数据文件的备份,其实只要scn 连续就行

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    205725