How To Increase Incremental Backup Speed with Block Change Tracking

 

You can increase the incremental backup speed with Block Change Tracking, which is one of the features that introduced with 10G.

When we enable this feature, backups are taken without checking the changing blocks. This means a very serious time saving.

The tracking of changing blocks is done with the Change Tracking Writer (CTWR) background process.

When Block Change Tracking is activated, the CTWR process will also start.

When a commit operation occurs, the block change information is copied into the field called CTWR buffer in the large pool.

In the Checkpoint process, the CTWR process writes the information in the CTWR buffer area to the change tracking file we specified when BCT was activated.

Based on my experience, a backup process time of 11 hours can be reduced to 50 minutes.

To use this feature, you need to activate it as follows. The “REUSE” statement in the command allows us to reuse the file if it was previously used.

 

The following query can be used to query the current status.

 

To disable this feature, the following command will be sufficient.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *