Answers to Review Questions - OCP: Oracle Database 12c Administrator Certified Professional - page 671

Chapter 6: Tuning and Monitoring RMAN
and the Automatic Diagnostic Workflow
1. C. The LIST BACKUP OF DATABASE command provides information on all database
backups that are available for restore via RMAN.
2. A. The CROSSCHECK command is used to validate all RMAN-related metadata with
associated physical backups on backup media.
3. B. The RESYNC CATALOG command is used to synchronize the recovery catalog with the
database control file.
4. D. The DURATION command is used to limit the overall time of a database backup.
5. E. The CATALOG command is used to load backup set pieces that do not already exist
into the recovery catalog or the control file.
6. B. Expired backup set pieces are those backup set pieces that do not exist. They are
discovered via the CROSSCHECK command and marked as expired. The LIST EXPIRED
command reports backup set records that are marked as expired. The DELETE
EXPIRED BACKUP command marks the backup metadata in the control file and recov-
ery catalog with a status of DELETED .
7. C, D. The DELETE OBSOLETE command will mark the related metadata records for the
backups as DELETED in the control file and the recovery catalog.
8. D. If a backup is expired, it means that a CROSSCHECK command has detected that one
or more backup set pieces associated with that backup are missing.
9. B. After you have corrected the reason that the backup set pieces are not available (i.e.,
replaced a failed disk), you would make the lost backup set available again by running the
CROSSCHECK command once the backup set piece becomes available on the backup media.
10. B. The backup will be allowed to run for 2 hours.
11. B, C, E. The backup will fail after the duration period expires, but the data files that
were backed up successfully will be able to be used in any restore operation. RMAN will
prioritize any data files not backed up in subsequent backups. Also, the backup will not
return an error when the duration expires and other commands will be executed.
12. B. This output would be from the V$SESSION view. It contains the current wait event
for each session as well as how long the wait has been occurring.
13. E. The V$SESSION_LONGOPS view is used to estimate how long a given running opera-
tion has until it is complete.