Oracle Database 12c: Installation and Administration — Question 76

You have successfully taken a database backup by using the command:
RMAN> BACKUP AS BACKUPSET DATABASE;
Now you execute this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome?

Answer options

• A. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.
• B. It fails because an incremental level 0 backup does not exist.
• C. It takes a backup of blocks that have been formatted since the last full database backup.
• D. It takes an incremental level 0 backup of the database.
• E. It first takes an incremental level 0 backup and then an incremental level 1 backup.

Correct answer: E

Explanation

The correct answer is E because when you request an incremental level 1 backup, RMAN first checks for an existing level 0 backup; if it doesn't find one, it automatically creates one before proceeding with the level 1 backup. Options A and B are incorrect as they misinterpret RMAN's behavior regarding the dependency on level 0 backups. Option C incorrectly describes the outcome of the command, and option D is incorrect as it does not reflect the actual process that RMAN follows.