nerdexam
Oracle

1Z0-052 · Question #37

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape: Which two statements are true about differential incremental backups?…

The correct answer is A. The backup performed on Sundays contains all the blocks that have ever been used in the database D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup. This question tests understanding of Oracle RMAN differential incremental backup levels and what each level captures relative to the backup hierarchy.

Performing Backup and Recovery

Question

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:

Which two statements are true about differential incremental backups? (Choose two.)

Options

  • AThe backup performed on Sundays contains all the blocks that have ever been used in the database
  • BThe backup performed on Sundays contains all the blocks that have changed since the last level 1 backup
  • CThe backup performed on each working day contains all the blocks that have changed since the last
  • DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup

How the community answered

(27 responses)
  • A
    74% (20)
  • B
    15% (4)
  • C
    11% (3)

Why each option

This question tests understanding of Oracle RMAN differential incremental backup levels and what each level captures relative to the backup hierarchy.

AThe backup performed on Sundays contains all the blocks that have ever been used in the databaseCorrect

A level 0 incremental backup is the baseline for all incremental backups and copies every data block that has ever been allocated or used in the database, regardless of when it was last changed. It is not a changed-block backup - it captures the full used-block footprint of the database.

BThe backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

A level 0 backup does not reference any prior level 1 - it is the base image that captures all ever-used blocks unconditionally, so 'blocks changed since the last level 1' is meaningless in the context of a level 0.

CThe backup performed on each working day contains all the blocks that have changed since the last

The statement as given describes cumulative incremental behavior (always going back to the level 0), not differential incremental behavior; a differential level 1 on Tuesday would go back only to Monday's level 1, not to Sunday's level 0.

DThe backup performed on Monday contains all the blocks that have changed since the level 0 backupCorrect

Monday is the first differential level 1 backup after Sunday's level 0, and since a differential level 1 copies all blocks changed since the most recent incremental backup at any level, Monday's backup captures all blocks changed since the level 0 (Sunday). There is no prior level 1 to reference, so level 0 is the parent.

Concept tested: Oracle RMAN differential incremental backup levels

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-backups.html

Topics

#differential incremental backup#level 0 backup#level 1 backup#RMAN backup strategy

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice