What command would you issue to enable automated backups of control files?
alter database controlfile autobackup on
alter system controlfile autobackup on
configure controlfile autobackup on
enable controlfile autobackup
Correct answer: C
Question 2
You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.
What must you set using the RMAN CONFIGURE command to achieve this?
MAXSETSIZE TO 2;
DEVICE TYPE DISK PARALLELISM 2;
RETENTION POLICY TO REDUNDANCY 2;
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Correct answer: D
Explanation:
Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link)
Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link)
Question 3
Which of the following best describes a full backup?
All datafiles of a database
All datafiles, archive logs, and control files
All datafiles and control files
All the used blocks in a datafile
Correct answer: D
Explanation:
From the training book:“Full backup: Makes a copy of each data block that contains data and that is within the files being backed up.”“A full backup contains all used data file blocks.” “A full backup is different from a whole database backup.” Conclusion – it means that not all data files are backed up when you do full backup.
From the training book:
“Full backup: Makes a copy of each data block that contains data and that is within the files being backed up.”
“A full backup contains all used data file blocks.”
“A full backup is different from a whole database backup.”
Conclusion – it means that not all data files are backed up when you do full backup.