If change tracking is enabled, RMAN uses the change tracking file to identify changed blocks for incremental backups, thus avoiding the need to scan every block in the datafile.
By default this is turned off, due to a very small performance overhead. When enabled the change tracking file is created as a Oracle Managed File in the DB_CREATEFILE_DEST location. You can choose to name the file your self and place it anywhere.
Enabling Change Tracking:
--Database must be mounted or open
SQL> alter database enable block change tracking;
--or name the file yourself
SQL>alter database enable block change tracking
USING FILE '/u01/app/oracle/rman_change_track.f'
REUSE;
Checking if change tracking is enabled:
SQL> select * from v$block_change_tracking;
STATUS FILENAME BYTES
---------- --------------------------------------------- -----
ENABLED +DATA/prod/changetracking/ctf.267.664766903 11599
Disable block change tracking:
SQL> alter database disable block change tracking;
******************************************
keywords: change tracking
******************************************
rdbms version: 10g - 11g
******************************************
No comments:
Post a Comment