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
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?
A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group
Answer: E
这两道题是否矛盾呢？第一道题有A，但第二道题为什么没有C呢？谢谢！
------解决方案--------------------
因为环境不一样，
------解决方案--------------------
楼主明白了什么时候使用resetlog以及resetlog之后Oracle做什么就不会如此迷糊
1）什么时候使用resetlog：
==>不完全恢复、
==>使用备份控制文件
==>在闪回数据库操作中
==>重建控制文件时RESETLOGS（一般在日志不完全或者部分日志损坏的时候用）
2）resetlog之后Oracle做了什么事情？
==》
指定RESETLOGS会执行下列操作：
① 归档当前Online Redolog File（如果能够访问到的话），然后清空内容并将SEQUENCE#重置为1（如果Online Redo Log File不存在，则重建）
② 重置Controlfile中关于Online Redo Log File的元数据
③ 更新Datafile和Online Redolog File中的RESETLOGS SCN和重置时间信息