RMAN block change tracking

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;

Share

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>