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

11. B. To perform the restore of data file 4, you would first need to take the data file
offline with the ALTER DATABASE command. Once the data file is offline, you would
use the RESTORE DATAFILE and RECOVER DATAFILE commands to restore and recover
the data file in question. After the restore and recover, you would need to bring the
data file back online.
12. C, E. This is not the correct way to address this problem. The command will fail
because the database is running. Additionally, this is not the correct way to approach
the loss of one of several control files. The better way to approach this loss is to shut
down the database and simply copy one of the surviving control files over to where the
missing control file existed.
13. A, C, D. The UNTIL TIME clause provides the ability to restore to a specific point in
time. The UNTIL SEQUENCE clause provides the ability to restore to a specific redo log
sequence number, and UNTIL SCN provides the ability to restore to a specific database
SCN number.
14. E. The RECOVER command does not restore data file images. It does restore and apply
archived redo logs and incremental backup images during the recovery process.
15. A, B, C, D, E. You will need to restore the data files associated with each tablespace in the
database in order to successfully complete the point-in-time database restore operation.
16. C. You would use the SWITCH DATAFILE command (for example, SWITCH DATAFILE 1
TO COPY ) to instantly switch to the image copy. Issue the RESTORE command and then
start up the database.
17. E. You would run the RMAN command RECOVER CORRUPTION LIST to recover the
corrupted blocks using block media recovery.
18. D. The commands will run without error until you attempt to open the database.
At that time, the ALTER DATABASE OPEN RESETLOGS command will fail. This will be
because data file 4 and the rest of the database will be inconsistent with each other and
Oracle does not allow this. If you are going to restore and recover an Oracle database
using point-in-time recovery, you must do so with the entire database.
19. E. For this recovery, you would use the RMAN SQL command to issue an ALTER
DATABASE DATAFILE OFFLINE command. You would then use the RMAN RESTORE
and RECOVER commands to recover the lost data file. Finally, you would use the
RMAN SQL command to issue the ALTER DATABASE DATAFILE ONLINE command.
20. C. To restore the database, in this case they needed to connect to the recovery catalog
with RMAN. They then started the DSL instance with the STARTUP NOMOUNT command
and restored the control file with the RESTORE CONTROLFILE command. After restoring
the control file, they mounted the database with the ALTER DATABASE MOUNT command
and then restored the database with the RESTORE DATABASE command. After restoring
the database, they recovered it with the RECOVER DATABASE command and then opened
it with the ALTER DATABASE OPEN RESETLOGS command.