Last updated on OCTOBER 12, 2016
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#;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms