Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three.)
Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three.)
Configuring CONTROLFILE AUTOBACKUP with RMAN ensures that the control file is automatically backed up in several situations. The control file is automatically backed up each time the SPFILE is backed up manually. Whenever an RMAN backup is successfully recorded in the catalog, it triggers an automatic control file backup. Additionally, when a new tablespace is created, it prompts a structural change that warrants an automatic backup of the control file to capture the updated state of the database structure. Therefore, the correct options are that the control file is backed up automatically each time the SPFILE is backed up manually, whenever an RMAN backup is successfully recorded in the catalog, and whenever a new tablespace is created.
For non-CDBs, if CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and the current server parameter file (if used to start the database) after a successful BACKUP command. For CDBs and standalone databases with the COMPATIBLE initialization parameter set to 12.0 or higher, by default, the control file autobackup is turned on. Chapter 8 About RMAN Control File and Server Parameter File Autobackups 8-15 If the database runs in ARCHIVELOG mode, RMAN makes control file autobackups when a structural change to the database affects the contents of the control file.
BEF correct https://www.dbi-services.com/blog/oracle-12c-automatic-control-file-backups/
Going ABF A: since the question says "by using RMAN", I won't consider a User Managed Backup by copying the SPFILE, what means that I have to used "BACKUP SPFILE". And AUTOBACKUP always backs up the control file after a BACKUP command, so A is correct. I'm considering E wrong because if the database is running in NOARCHIVELOG mode the autobackup won't run after a structural change.
E is true because of datafiles of tablespace. Datafiles are physical structures and controlfile contains information of physical structures. New entry in controlfile means new autobackup
ABF can be correct. E is true only if database is configured in ARCHIVELOG mode and question doesn't specify this
B,E,F correct
BEF, i agree
RMAN> backup current controlfile; Starting backup at 10-DEC-23 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=55 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 10-DEC-23 channel ORA_DISK_1: finished piece 1 at 10-DEC-23 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/012dlsh6_1_1 tag=TAG20231210T084525 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 10-DEC-23 Starting Control File and SPFILE Autobackup at 10-DEC-23 piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2926183155-20231210-00 comment=NONE Finished Control File and SPFILE Autobackup at 10-DEC-23
why not A？ A=B
Oracle Database 12c Release 2 (12.2) DBUA : Understanding New Changes / Features (Doc ID 2171985.1)