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.
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)- A4% (1)
- B91% (21)
- D4% (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.
Data files require explicit RMAN backup commands and are not part of the autobackup feature, which is limited to control files and the SPFILE.
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.
The text-based parameter file (PFILE/init.ora) is not included in RMAN autobackup; only the binary SPFILE is covered by this feature.
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.
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
Community Discussion
No community discussion yet for this question.