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 吧。
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.