CTWR

From Oracle FAQ
Jump to: navigation, search

CTWR (Change Tracking Writer) is an Oracle background process created when you start an instance with BLOCK CHANGE TRACKING enabled. This feature improves incremental RMAN backup performance by recording changed blocks in each datafile in a tracking file. RMAN uses the tracking file to identify changed blocks for incremental backup, thus avoiding the need to scan every block in the datafile.

To enable:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE os_file_name;

Monitor:

SELECT filename, status, bytes
  FROM v$block_change_tracking;
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #