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 CONTROLFILE AUTOBACKUP is ON, RMAN automatically creates a control file autobackup after certain operations, regardless of whether a control file was already included in the backup set. This ensures redundancy and recoverability even if recent backups exist.

Keep practicing — related questions