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.
Question
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)- A84% (26)
- C10% (3)
- D6% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.