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

14. B. The users01.dbf data file has had an unrecoverable operation occur. Because an unre-
coverable operation does not generate redo records, the data involved in that operation
will be lost in the event of a recovery. The data file should be backed up.
15. B. The #bkps column shows zero, which indicates that the data file has not been backed
up. The data file may still be recoverable as long as the archived redo logs are available.
16. C. RMAN will attempt to spread the overall I/O over the total stated duration of the
backup listed in the DURATION parameter. This will have the effect of limiting the overall
load on the database and reducing the performance impacts of the backup.
17. E. This command lists all database data files that would require that more than three
days of archived redo logs be applied in order to be restored.
18. C. ADRCI provides an interface into the ADR repository and provides the ability to
review and manage files contained in that directory.
19. A, C, D. The Fault Diagnosability Framework includes a number of components.
The ADR component is the persistent file system structure and related metadata that
defines the location where files from the Framework should be stored. The alert log
and trace files are critical files that are used to diagnose database incidents.
20. A, B. The Fault Diagnosability Framework provides the ability to manage Oracle SRs,
including opening the SR and collecting files related to the problem/incident related to
the SR and sending those files to Oracle.
Chapter 7: Performing Oracle
Advanced Recovery
1. B. RMAN supports duplication of an individual PDB, several PDBs, or the entire CDB
to another CDB.
2. B. The RECOVER TABLESPACE command is used to start a TSPITR recovery.
3. B. Active database duplication does not require any backup before the duplication is run.
4. E. The commands in option E are the correct commands to perform an active database
duplication given the conditions listed.
5. B. You will use two databases. The first is the target database, and the second is the
auxiliary database instance.
6. C. The RESET DATABASE TO INCARNATION command is used to reset the database
incarnation.