My Oracle Support Banner

How to Manage and Evaluate the Block Change Tracking Benefits (Doc ID 2821967.1)

Last updated on APRIL 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Purpose

Help DBAs determine if block change tracking (BCT) will help backup performance or impact database performance.

Scope

 Intended for DBAs tuning or trying to determine if using block change tracking (BCT) will be beneficial to the system overall.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Guidance between enabling or disabling block change tracking (BCT) for incremental backups
 When enabling BLOCK CHANGE TRACKING, ideally place the file in an ASM disk group.
 Customers can get the following benefits when enabling BCT:
 When will BCT be of beneficial?
 When not to enable BCT?
 Configuration Practices when enabling BCT
 Operational Practices when enabling BCT
 Troubleshooting RMAN backups with BCT
 BCT Known Issues:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.