OCP CBT Question 691

Please solve the following question.

You want to ensure the recoverability of your database against the loss of a control file due to a disk failure. Which action should you take to multiplex the control files?

The control file is an essential binary file for database operation, containing metadata about the database's physical structure, such as data file and redo log file names and locations, and information required for recovery. Losing all copies of the control file can make database recovery very difficult or impossible.

Create a new control file using the CREATE CONTROLFILE command regularly.

Set the CONTROL_FILES initialization parameter to list multiple copies of the control file on different disks.

Enable RMAN control file autobackup to store control file backups in the Flash Recovery Area.

Regularly back up the control file using operating system commands.