Oracle Database 12c: Installation and Administration — Question 20

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)

Answer options

• A. inactive online redo log file group
• B. a data file belonging to the default temporary tablespace
• C. a data file belonging to the SYSAUX tablespace
• D. server parameter file (SPFILE)
• E. active online redo log file group
• F. all the control flies

Correct answer: A, E, F

Explanation

Losing the inactive online redo log file group (A), the active online redo log file group (E), and all control files (F) can prevent an incomplete recovery because these files are crucial for applying redo information and maintaining the database's consistency during recovery. Other options like a data file from the default temporary tablespace or SYSAUX tablespace are not critical for recovery completeness.