ITPub博客

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

043-124

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-08 10:17:59 0 删除 编辑
124. You are using Oracle Database 10g. You performed an incomplete r
ecovery of your database and opened the database with the RESETLOGS o
ption. What is the effect of opening the database with the RESETLOGS
option? (Choose two)
A. This operation resets the SCN for the database.
B. This operation creates a new incarnation of the database.
C.This operation moves all the redo log files to a different location
D. This operation deletes the old redo log files and creates new redo
log files.
E. This operation updates all current datafiles and online redo logs
and all subsequent archived redo logs with a new RESETLOGS SCN and ti
me stamp.
Answer: B, E
select file#,checkpoint_change# from v$datafile;
select file#,checkpoint_change# from v$datafile_header;
只要以上两个不一致,就需要resetlog 打开
alter database open resetlogs; 即截断多余的scn , resetscn 更好
a.截断scn (有疑问) (warehous)
b.把当前日志归档
c.序列号从1 开始了 重建日志了

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203194