Dell Avamar for Oracle 19.10 User Guide

Enabling Block Change Tracking

The Block Change Tracking feature can improve level 1 (differential and cumulative) backup performance by recording changed blocks in each datafile in a block change tracking file.

1. Determine whether Block Change Tracking is enabled by typing the following command from an SQL prompt:
   select status from v$block_change_tracking;
   The STATUS column shows whether Block Change Tracking is enabled. The FILENAME column contains the file name of the block change tracking file. Oracle documentation provides more information about v$block_change_tracking.
2. Enable Block Change Tracking by typing the following command from an SQL prompt:
   alter database enable block change tracking using file 'filename';
   where filename is the absolute pathname of the file to be used for Block Change Tracking. Oracle uses this file to track datafile changes. Oracle documentation provides more information about Block Change Tracking.

   NOTE:To schedule level 0, level 1 differential, and level 1 cumulative backups, create three backup schedules: one for level 0 backups, one for level 1 differential backups, and one for level 1 cumulative backups. Scheduling backups provides more information.