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

Chapter 5: Recovering Databases
with RMAN
1. C. Enable control-file autobackups by executing the command CONFIGURE CONTROLFILE
AUTOBACKUP ON .
2. D. You would shut down the database with the SHUTDOWN IMMEDIATE command before
the recovery. You would then issue the RESTORE DATABASE command followed by the
RECOVER DATABASE command. After you have recovered the database, you will want to
open it with the STARTUP command.
3. A, D. The RESTORE command is used to restore data files during a database recovery.
The RECOVER command is used to apply incremental backups and archived redo logs
to recover the database to the needed point in time.
4. D. In the event of complete loss of your database, you will need to first restore the data-
base spfile. Once you have restored the database spfile, you will need to restore the
database control file. Having restored the database control file, you would restore
the database and then recover the database. Finally, since this would be an incomplete
recovery (because you lost the entire database, the online redo logs are gone too), you
would need to open the database using the ALTER DATABASE OPEN RESETLOGS command.
5. B. A loss of the entire database will require an incomplete database recovery. This is
because the online redo logs would not be available to perform a complete recovery.
6. C. The RESTORE DATABASE command is used to restore database data files. The UNTIL
TIME parameter is used to indicate the point in time to which you want to restore the
database data files.
7. D. Since the retention policy is set to redundancy of 1, the gold_copy backup is not
required to meet the retention criteria. Since the backup was not made in a way that
will exclude or alter the retention criteria, then the gold_copy backup is no longer
needed and may be removed at any time. It is possible that it will still be available for
restore purposes, however.
8. C. The online redo logs are never backed up by Oracle no matter what kind of backup
you are performing.
9. B. There is no equivalent RMAN command that creates a trace file with the CREATE
CONTROLFILE statement in it.
10. A. In this case, you would first issue the RESTORE DATABASE command using the UNTIL
TIME option. You would then use the RECOVER DATABASE command using the same
UNTIL TIME option. Finally, since this is an incomplete recovery, you would need to
open your database with the ALTER DATABASE OPEN RESETLOGS command.