In this article we are going to see use of Oracle Block Change Tracking concept in 18cR2 database.
18cR2-Block Change Tracking(BCT)
- Oracle 10g introduced the Block change tracking (BCT) feature which is used to Speed up Rman Incremental Backup.
- After Enabling this feature records the modified since last backup and stores the log of it in a block change tracking file using the CTWR (Change Tracking Writer) process.
- Records the modified since last backup and stores the log of it in a block change tracking file.
- Block change tracking feature is not reading the entire database blocks it just directly reads only changed blocks results in block change tracking file.
- During backups Rman uses the log file to identify the specific blocks that must be backed up.
- It improves the Rman performance as it is not scan whole datafiles instead of read the changed blocks and take backups .
Enable Block Change Tracking.
Alter database enable block change tracking using file ‘/u02/app/oracle/oradata/ORCL18c/changetracking/bctfile.log’;
Select filename,status from V$block_change_tracking;
Disable block change Tracking
Catch Me On:- Hariprasath Rajaram
FB Page: https://www.facebook.com/dbahariprasath/?