ITPub博客

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

043-180

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-10 11:09:36 0 删除 编辑
180. You are working on Oracle Database 10g, which is in ARCHIVELOG m
ode. All the archived log files are intact. In which scenario would p
erforming a recovery require the opening of the database with the RES
ETLOGS option?
A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group
Answer: E
丢了部分没有归档的redo log,可以使用基于取消的恢复,打开数据库的时
候必须要使用resetlogs,主要是数据文件头跟控制文件里记录scn 不一致.
select file#,checkpoint_change# from v$datafile;
select file#,checkpoint_change# from v$datafile_header;

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203209