Oracle 18cR2-Rman Performance of Block change Tracking (BCT)
Description:-
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;
Ctwr (change tracking writer process started)
Disable block change Tracking
Catch Me On:- Hariprasath Rajaram
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
