RMAN incremental level 1 backups are not using block change tracking file
(Doc ID 1192652.1)
Last updated on JANUARY 25, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 18.104.22.168 [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
round((blocks_read/datafile_blocks) * 100,2) "%READ",
blocks WRTN, round((blocks/datafile_blocks)*100,2) "%WRTN"
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')
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