RMAN's change tracking feature for incremental backups improves incremental backup performance.
With change tracking feature RMAN creates a file named change tracking file and then any blocks changes entry is recorded in the file.
After enabling change tracking, the first level 0 incremental backup still has to scan the entire datafile, as the change tracking file does not yet reflect the status of the blocks. Subsequent incremental backup that use this level 0 as parent will. use the change tracking file to identify changed blocks.
Enable and disable Change Tracking
-------------------------------------------------
Block change tracking can enabled by
SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
The file will be created in the DB_CRETE_FILE_DEST if it is set. However manually can be set by
SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/oradata2/change_tracking.f';
To disable change tracking, use this SQL statement:
SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
Query V$BLOCK_CHANGE_TRACKING to know the status and filename of block change tracking.
No comments:
Post a Comment