The loss of which two types of files may require a recovery with
the RESETLOGS option?(Choose two.)
A. control files
B. password file
C. archived log files
D. system-critical data files for which all the redo entries are
present
E. non-system-critical data files for which all the redo entries
are present
Answer: A, C
幾點總結:(eygle:)
1:只要擁有當前日志文件,就可以執行完全恢復,是否需要 resetlogs 方式打開,
取決是否使用備份的控制文件。
2:如果日志文件沒有損失,可以通過重建控制文件的方法來完成完全恢復,這種
情況下,不再需要通過 resetlogs 方式打開數據庫。