Skip to main content
Delphix

Consider Enabling Block Change Tracking (BCT) to Improve Snapsync Performance Times (KBA1651)

 

KBA

KBA# 1651

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

How Block Change Tracking (BCT) Can Improve Oracle SnapSync Times

When a virtual database (VDB) is being provisioned, Delphix first creates a virtual copy of the most recent datasource snapshot, and then performs a roll-forward recovery to the specified point-in-time using transaction logs. The more transaction logs (i.e. Oracle redo logs) that need to be applied, then the longer the VDB provision operation will take.

When the underlying datasource is an Oracle dSource, snapshots are created by the SnapSync service, which uses the Oracle RMAN utility to capture changes in the source database. The Oracle RMAN utility is performing an incremental datafile backup to capture datafile changes. Unless BCT is enabled, RMAN must scan the entire database to find the changed data blocks within the database datafiles.

If BCT is enabled, then a list of changed blocks is maintained within a Block Change file outside the database. Incremental backups merely read from the list to locate the changed blocks, reducing the elapsed time of incremental backups substantially. 

For a more detailed explanation please refer to the Oracle online documentation:

Using Block Change Tracking to Improve Incremental Backup Performance

Enabling and Disabling Block Change Tracking

Checking Whether Change Tracking Is Enabled

Block Change Tracking (BCT) and Delphix

The Delphix Engine supports linking both physical and logical standby databases. In general, Delphix recommends enabling Block Change Tracking (BCT) on a primary or standby source database.

For further recommendations regarding enabling BCT on an Oracle Physical Standby Databases please refer to the Delphix Engine online documentation, Linking Oracle Physical Standby Databases.