052试题 80 - differential incremental bakcup

题目：

80. You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape.
Which two statements are true about differential incremental backups? (Choose two.)
A.The backup performed on Sundays contains all the blocks that have ever been used in the database.
B.The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
C.The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.
D.The backup performed on Monday contains all the blocks that have changed since the level 0 backup, and every other working day contains all the blocks that have changed since the level 1 backup.

参考答案 AD

解析：
题目意思是，在周日执行了level0 备份(其实就是全备份，这种备份可以使用增量备份)，其他时间每天执行了差异增量备份(differential incremental level1)，关于差异增量备份，那种说法是正确的。
周日是level 0 备份，所以周日的备份包含了全部的blocks。也就是周日做了一个全备份。所以A正确，B错误。
每天的差异增量备份，是和上一天的对比，只备份有差异的备份，而不是和level 0 对比做备份，所以C错误。D正确。

参考文档：

https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV89499

Multilevel Incremental Backups

RMAN can create multilevel incremental backups. Each incremental level is denoted by a value of 0 or 1. A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing data. You can create a level 0 database backup as backup sets or image copies.

The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy. Thus, an incremental level 0 backup is a full backup that happens to be the parent of incremental backups whose level is greater than 0.

A level 1 incremental backup can be either of the following types:

• A differential incremental backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0

• A cumulative incremental backup, which backs up all blocks changed after the most recent incremental backup at level 0

Incremental backups are differential by default.

Note:

Cumulative backups are preferable to differential backups when recovery time is more important than disk space, because fewer incremental backups must be applied during recovery.

The size of the backup file depends solely upon the number of blocks modified, the incremental backup level, and the type of incremental backup (differential or cumulative).

Differential Incremental Backups

In a differential level 1 backup, RMAN backs up all blocks that have changed since the most recent incremental backup at level 1 (cumulative or differential) or level 0. For example, in a differential level 1 backup, RMAN determines which level 1 backup occurred most recently and backs up all blocks modified after that backup. If no level 1 is available, then RMAN copies all blocks changed since the base level 0 backup.

If no level 0 backup is available in either the current or parent incarnation, then the behavior varies with the compatibility mode setting. If compatibility is >=10.0.0, RMAN copies all blocks that have been changed since the file was created. Otherwise, RMAN generates a level 0 backup.

Figure 8-2 Differential Incremental Backups

Description of "Figure 8-2 Differential Incremental Backups"
 

In the example shown in Figure 8-2, the following activity occurs each week:

• Sunday

  An incremental level 0 backup backs up all blocks that have ever been in use in this database.

• Monday through Saturday

  On each day from Monday through Saturday, a differential incremental level 1 backup backs up all blocks that have changed since the most recent incremental backup at level 1 or 0. The Monday backup copies blocks changed since Sunday level 0 backup, the Tuesday backup copies blocks changed since the Monday level 1 backup, and so forth.

END