小弟有032问题,求解

[复制链接]
查看11 | 回复2 | 2010-3-1 11:08:28 | 显示全部楼层 |阅读模式
1、Which two circumstances could require an incomplete recovery? (Choose two.)
A.You need to restore a damaged mirrored archived redo log file.
B. A previously unused mirrored copy of a lost control file has been
restored.
C. You need to reverse the mass update of a significant number of
tables and are unsure when the error occurred.
D.A damaged control file has been restored from backup, and a binary
version of the restored control file does NOT exist.
E.You need to recover to a previous point-in-time before there were a
number of significant structural changes made to the database that
need to be reversed.

答案是C、E,我认为是C、D。不知道对不对。拜求各位大哥
回复

使用道具 举报

千问 | 2010-3-1 11:08:28 | 显示全部楼层
应该还是C、E 吧。
SG 上提到Reason for Performing Incomplete Recovery 时,包括有:
All control files are lost.
User error (An important table was dropped 和Invalid data was committed in a table)
同时,提到Type of Incomplete Recovery 时,有Timed-based、Cancel-based、Change-based
但是在说到对于All control files are lost 情况下的原因时,提到but you have a backup of an old binary copy.
回复

使用道具 举报

千问 | 2010-3-1 11:08:28 | 显示全部楼层
多谢斑竹大哥,小弟佩服。看来SG还是看得不够仔细。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行