ITPub博客

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

043-022

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-04 14:41:02 0 删除 编辑
22. You performed an incomplete recovery on your Oracle Database 10g
database using the following command:
SQL> RECOVER DATABASE
2 UNTIL TIME '2004-08-05:12:10:03'
3 USING BACKUP CONTROLFILE;
In which situation would the above recovery be required?
A. A user table was lost at the specified time.
B. A redo log file was lost at the specified time.
C. The backup control file is on a faster disk than the current one.
D. The current control file has a different path compared with the in
tended time of recovery.
E. The current control file does not match the physical structure of
the database at the intended time of recovery.
Answer: E
using backup controlefile表示基于备份控制文件的恢复。只有数据文件比较新的时候要用这种恢复。

RESETLOGS会做下面几件事情
1.归档当前的联机日志文件(online redo logs)
2.把日志序列号重设置成1(log sequence number)
3.ORACLE会用新的SCN更新所有的数据文件,联机日志文件,归档日志文件。

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203392