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

16. E. In this situation, you have gotten yourself in real trouble and you will have data loss.
First, you will need to restore the last full database backup and also all archived redo
logs that were generated during the backup and since the backup was completed. You
will then issue the STARTUP MOUNT command to mount the database, and then issue the
RECOVER DATABASE UNTIL CANCEL command. Apply all the archived redo logs that you
can. Then cancel the recovery and open the database using the ALTER DATABASE OPEN
RESETLOGS command.

17. A. The SCN is a number that represents a point in time in the database relative to
transactions within a given database.

18. A. If you have only lost a data file, you should just restore and then recover the data file.

19. A, C. This error will appear if an archived redo log is not available. In this case, you
need sequence 11. First you would try to restore archived redo log sequence 11. If log
sequence 11 is not available as an archived redo log, you might find that it is available
in one of the online redo logs.

20. A, E. The V$LOGFILE view will give you the name of the online redo logs associated
with each group. The V$LOG view will provide the current sequence number assigned
to each group.

Chapter 3: Configuring and Backing Up
Oracle Databases Using RMAN

1. A. Block-change tracking must be enabled with ALTER DATABASE ENABLE BLOCK
CHANGE TRACKING . The physical location and name of the block-change tracking file
must be supplied.

2. A. The backup set is stored in a proprietary RMAN format, where only used blocks
are backed up.

3. D. The following four backup sets would be created:

One for an archive log backup before the main backup.

■

One for the main backup. Since we are using a single channel with no backup-set
size restriction, RMAN would create a single backup set.

■

One for an archive log backup after the main backup.

■

One for the control-file autobackup.

■

4. A. The BACKUP AS COPY command is used to create an image-copy backup.

5. C. Compressed backups work only with backup sets, not image copies. Thus, compressed
backups will work only with the BACKUP command.