ITPub博客

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

043-033

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-05 09:32:03 0 删除 编辑
33. Your database operates in ARCHIVELOGmode. The redo log files are
not multiplexed and one of the online redo logs is missing. The missi
ng redo log sequence, 230, is not archived and it contained informati
on from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of
a disk crash, you executed the following command to perform. an incom
plete recovery:
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESETLOGS;
7> };
With reference to this scenario, which statement is true?
A. RMAN recovers up to log sequence 230, but not including 230.
B. RMAN returns an error because the log sequence number mentioned in
the command should be 229.
C. RMAN returns an error because the log sequence number mentioned in
the command may never be missing.
D. RMAN recovers up to and including log sequence 229 but then return
s an error because log sequence 230 is missing.
Answer: A
由于未被归档redo log file 丢失,比如说230 丢失,如果不执行基于取消的
恢复,那么数据库只能恢复到229,使用命令SET UNTIL SEQUENCE 230 THREAD 1
recover database until '2009/12/27 14:37:24';
恢复出来是小于那个时间点
http://www.itpub.net/thread-1014022-1-1.html

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    213946