Multiple choice

If the following command is issued: rman> CONFIGURE CONTROLFILE AUTOBACKUP ON; Which of the following statements is true?

  1. The autobackup of the control file will occur even if a backup set that included a control file backup just occurred.

  2. The control file autobackup will occur only after a BACKUP command is issued.

  3. The autobackup of the control file will not occur if an identical control file backup currently exists on the device to be written.

  4. The 'CONFIGURE CONTROLFILE AUTOBACKUP ON;' command has no effect because the control file autobackup feature is enabled by default.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When CONFIGURE CONTROLFILE AUTOBACKUP ON is enabled, RMAN automatically creates a control file autobackup after every backup operation, regardless of whether the backup set already includes a control file backup. This provides an extra layer of protection for the control file, which is critical for database recovery.

Keep practicing — related questions