nerdexam
Oracle

1Z0-052 · Question #39

You are managing an Oracle Database 11g database with the following backup strategy: 1. On Sunday, an incremental level 0 tape backup is performed 2. Monday through Saturday, a cumulative…

The correct answer is A. The backup performed in step 1 backs up all blocks that have ever been in use in the database B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup. This question tests understanding of Oracle RMAN cumulative incremental backups, which always reference the most recent level 0 rather than the most recent backup of any level.

Performing Backup and Recovery

Question

You are managing an Oracle Database 11g database with the following backup strategy: 1. On Sunday, an incremental level 0 tape backup is performed 2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed Which two statements are true regarding the backups performed? (Choose two.)

Options

  • AThe backup performed in step 1 backs up all blocks that have ever been in use in the database
  • BThe backup performed in step 2 copies all the blocks changed since the most recent level 0 backup
  • CThe backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup
  • DThe backup performed in step 2 backs up all blocks that have changed since the most recent incremental

How the community answered

(31 responses)
  • A
    84% (26)
  • C
    10% (3)
  • D
    6% (2)

Why each option

This question tests understanding of Oracle RMAN cumulative incremental backups, which always reference the most recent level 0 rather than the most recent backup of any level.

AThe backup performed in step 1 backs up all blocks that have ever been in use in the databaseCorrect

A level 0 incremental backup copies every data block that has ever been used in the database, serving as the base image from which all subsequent incremental backups are derived. It does not filter by change time.

BThe backup performed in step 2 copies all the blocks changed since the most recent level 0 backupCorrect

A cumulative level 1 backup, unlike a differential level 1, always backs up every block that has changed since the most recent level 0 backup regardless of whether a more recent level 1 exists. This means each Monday-Saturday backup captures all changes since Sunday's level 0, growing in size throughout the week.

CThe backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup

A level 0 backup does not reference any prior level 1 - it unconditionally captures all used blocks and serves as the base image, not a changed-block backup relative to level 1.

DThe backup performed in step 2 backs up all blocks that have changed since the most recent incremental

Backing up all blocks changed since the most recent incremental backup at any level describes differential level 1 behavior, not cumulative level 1 behavior; cumulative always measures from the level 0.

Concept tested: Oracle RMAN cumulative incremental backup strategy

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

Topics

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

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice