1Z0-062 · Question #277
Backup requirements for a database: Level 0 backup on Sunday Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday * Differential incremental level 1 backup on Tuesday, Thursday…
The correct answer is B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup. D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since. This question tests understanding of Oracle RMAN incremental backup types: Level 0, Level 1 Cumulative, and Level 1 Differential, and what data they contain relative to their backup schedule.
Question
Backup requirements for a database:
- Level 0 backup on Sunday
- Cumulative incremental level 1 backup on Monday, Wednesday, and
Saturday
- Differential incremental level 1 backup on Tuesday, Thursday, and
Friday Which three statements are true about the strategy? (Choose three.)
Options
- ALevel 0 backup on Sunday contains all the blocks that have been formatted.
- BLevel 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
- CLevel 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since
- DLevel 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed
- ELevel 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since
How the community answered
(27 responses)- A19% (5)
- B74% (20)
- C7% (2)
Why each option
This question tests understanding of Oracle RMAN incremental backup types: Level 0, Level 1 Cumulative, and Level 1 Differential, and what data they contain relative to their backup schedule.
A Level 0 backup contains all blocks that have ever been used (allocated and written to) in the datafiles, making it a full backup of the used data, not necessarily all blocks that have merely been formatted.
A Level 0 backup acts as the baseline for all subsequent incremental backups. While it contains all used blocks, from the perspective of the incremental strategy, it effectively signifies that all blocks are 'changed' or form a new starting point, rendering previous Level 1 incremental states irrelevant for a recovery path that begins from this Level 0.
This statement is an incomplete description; a Level 1 differential backup on Tuesday, Thursday, and Friday contains all blocks that have been changed since the *most recent Level 0 or Level 1 backup* of any type.
A Level 1 cumulative incremental backup backs up all blocks that have changed since the most recent Level 0 backup. In this strategy, the Level 1 cumulative backups on Monday, Wednesday, and Saturday would each capture all changes made since the Level 0 backup on Sunday.
A Level 1 differential incremental backup backs up all blocks that have changed since the most recent Level 0 or Level 1 backup of any type. In this strategy, the Level 1 differential backups on Tuesday, Thursday, and Friday would capture changes since their immediate preceding Level 0 or Level 1 backup.
Concept tested: RMAN Level 0, Level 1 Cumulative, Level 1 Differential backups
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-incremental-backups.html
Topics
Community Discussion
No community discussion yet for this question.