nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • A
    19% (5)
  • B
    74% (20)
  • C
    7% (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.

ALevel 0 backup on Sunday contains all the blocks that have been formatted.

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.

BLevel 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.Correct

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.

CLevel 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since

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.

DLevel 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changedCorrect

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.

ELevel 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed sinceCorrect

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

#RMAN backup types#Incremental backup#Level 0 backup#Cumulative backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice