nerdexam
Oracle

1Z0-052 · Question #169

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

The correct answer is B. Control Files E. Server Parameter File. The RMAN autobackup feature is specifically designed to automatically back up two critical database files - the control file and the server parameter file (SPFILE) - whenever a backup or structural change occurs.

Performing Backup and Recovery

Question

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

Options

  • AData Files
  • BControl Files
  • CParameter Files
  • DOnline Redo Log Files
  • EServer Parameter File

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    91% (21)
  • D
    4% (1)

Why each option

The RMAN autobackup feature is specifically designed to automatically back up two critical database files - the control file and the server parameter file (SPFILE) - whenever a backup or structural change occurs.

AData Files

Data files require explicit RMAN backup commands and are not part of the autobackup feature, which is limited to control files and the SPFILE.

BControl FilesCorrect

Control files are automatically backed up by RMAN autobackup because they contain critical database structure information; RMAN triggers this automatically after backup operations or structural changes.

CParameter Files

The text-based parameter file (PFILE/init.ora) is not included in RMAN autobackup; only the binary SPFILE is covered by this feature.

DOnline Redo Log Files

Online redo log files cannot be backed up by RMAN at all, as they are always kept current and are not included in any RMAN backup operation.

EServer Parameter FileCorrect

The Server Parameter File (SPFILE) is included in the autobackup because it stores persistent initialization parameters; RMAN backs it up automatically alongside the control file to ensure database recoverability.

Concept tested: RMAN autobackup of control file and SPFILE

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-basic.html

Topics

#RMAN autobackup#control file backup#SPFILE backup#automatic backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice