Oracle Database 12c: Advanced Administration — Question 24

For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

Answer options

• A. It returns an error because there is no level 0 backup available for new data files.
• B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
• C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
• D. It performs an image copy backup of all data files including those that belong to the new tablespace.
• E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Correct answer: B

Explanation

The correct answer is B because the command performs a level 1 incremental backup for all files that already exist while taking an image copy of new data files. Options A and C are incorrect as there is no level 0 backup requirement for the command to execute, and options D and E do not accurately describe the backup type performed for existing files.