RMAN 10g : How To Size the Block Change Tracking File (Doc ID 306112.1)

Last updated on MARCH 10, 2017

Applies to:

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

Goal

This is a clarification of the documentation for sizing the disk space for the Block Change Tracking File.

The actual size of the Block Change Tracking File is determined by Oracle and cannot be changed by the end user.
The size of the block change tracking file can increase and decrease as the database changes.
The size is not related to the frequency of updates to the database.

Block Change Tracking is used to optimize incremental backups.
A new file is introduced:

- Changed blocks are tracked by the CTWR background process as redo is generated
- Database backups automatically use the change tracking file


Sizing of this file is important, and even though you can use V$BLOCK_CHANGE_TRACKING view
to monitor the usage, it may in some cases not be easy to change the size, ie when using raw devices.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms