My Oracle Support Banner

RMAN incremental level 1 backups are not using block change tracking file (Doc ID 1192652.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
*** ***


With block change tracking enabled, during an rman level 1 incremental backup it can be observed that block change tracking is not used for datafiles. Using this query to determine if block change tracking is being used for the backup. Change the RMAN owner, date and time, and db_id to match your environment:

Replace the completion_time accordingly in the below query


file# fno,
used_change_tracking BCT,
incremental_level INCR,
datafile_blocks BLKS,
block_size blksz,
blocks_read READ,
round((blocks_read/datafile_blocks) * 100,2) "%READ",
blocks WRTN, round((blocks/datafile_blocks)*100,2) "%WRTN"
from rman102.rc_backup_datafile
where completion_time between
to_date('08-10-2010 09:00:00', 'MM-DD-YYYY HH24:MI:SS') and
to_date('08-10-2010 13:00:00', 'MM-DD-YYYY HH24:MI:SS')
and db_key=458227
order by file#;



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

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