Oracle Database 12c: Installation and Administration — Question 213

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
/mydir/rman_change_track.f;
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)

Answer options

• A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
• B. The change tracking file must always be backed up when you perform a full database backup.
• C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
• D. More than one database block may be read by an incremental backup for a change made to a single block.
• E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed

Correct answer: A, D, E

Explanation

Option A is correct because block change tracking can optimize I/O by reducing the amount of data read during cumulative backups. Option D is also correct as multiple blocks may need to be accessed if a single block's change affects them. Option E is true since the first incremental level 1 backup post-enablement doesn't reference the change tracking file until subsequent backups, making options B and C incorrect.