Oracle Database Administration II — Question 160

Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three.)

Answer options

• A. The control file is backed up automatically each time the SPFILE is backed up manually.
• B. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.
• C. It requires the use of fast recovery area (FRA).
• D. The control file is backed up whenever a new table is created.
• E. The control file is backed up whenever a new tablespace is created.
• F. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

Correct answer: B, E, F

Explanation

The correct answers B, E, and F are true because the control file is indeed backed up automatically when an RMAN backup is recorded in the catalog, when a new tablespace is created, and the SPFILE is backed up whenever the control file is backed up. Options A, C, and D are incorrect as they do not reflect the actual behavior of CONTROLFILE AUTOBACKUP functionality.