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

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Apr-2014***
***Checked for relevance on 20-Jul-2015***


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#;



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