Multiple choice

Intermittent hardware problems are being experienced with the disk drive on which the control file is located. It is decided to multiplex the control file. While the database is open, the following steps were performed:

  1. A copy of the control file was made using an operating system command.
  2. A new file name was added to the list of files for the CONTROL FILES parameter in the text initialization parameter file, using an editor.
  3. The instance was shut down.
  4. The STARTUP command was issued to restart the instance, mount, and open the database. The instance starts, but the database mount fails. Why?

  1. The control file was copied before shutting down the instance.

  2. An operating system command was used to copy the control file.

  3. The Oracle server does not know the name of the new control file.

  4. A new control file name was added to the CONTROL_FILES parameter before shutting down the instance.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Control files must be copied when the database is completely shut down. Copying a control file while the database is open results in an inconsistent copy because the control file is being actively updated. When you try to mount using this inconsistent copy, Oracle detects the mismatch and fails the mount operation.

Keep practicing — related questions