Enabling block change tracking file for RMAN backups enables the backups to perform better. By reading the tracking file, RMAN is able to determine the changed blocks much faster than scanning the entire datafile for changed blocks.
Enable blocking tracking for a database on ASM:
alter database enable block change tracking using file ‘/oracle/u01/backup/rman/change_tracking.ctl’;
The below command create a block change tracking file for the database on ASM.
alter database enable block change tracking using file ‘+DATA01′;
Check the status:
SELECT filename, status, bytes FROM v$block_change_tracking;
Disable block change tracking:
ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
