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.)
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
C.
The backup performed in step 1 backs up all the blocks changed since the most recent level 1
backup
D.
The backup performed in step 2 backs up all blocks that have changed since the most recent
incremental backup at level 1
Shouldnt the ans be A and D??
In the question they asked for Cumulative Incremental not the differential Incremental
A&B Correct answers
A wrong (it is in fact possible to use a block, then remove the data from it an shrink the tablespace below this block ie this block is not backed up)
B right
C right, this and more
D right, this and more
An incremental backup is either a level 0 backup, which includes every block in the file except blocks compressed out because they have never been used, or a level 1 backup, which includes only those blocks that have been changed since the parent backup was taken. A level 0 incremental backup is physically identical to a full backup. The only difference is that the level 0 backup can be used as the parent for a level 1 backup, but a full backup will never be used as the parent for a level 1 backup