Friday , October 20 2017
Home / Oracle DBA / Improving Incremental RMAN Backup Performance: Change Tracking

Improving Incremental RMAN Backup Performance: Change Tracking

Improving Incremental RMAN Backup

RMAN’s change tracking feature for incremental backups improves incremental backup performance by recording changed blocks in each datafile in a change-tracking file. If change tracking is enabled, RMAN uses the change-tracking file to identify changed blocks for incremental backup, thus avoiding the need to scan every block in the datafile. There is a new background process responsible for writing data to the block change- tracking file, which is called Block Change Writer CTWR.

Enabling and Disabling Change Tracking

You can enable or disable change tracing when the database is open. To alter the change tracking setting, you must use SQL* Plus to connect to the target database with administrator privileges.

  1. You can enable this tracking mechanism by issuing the following command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘/w001/backup/ORCL/rman/change.log’;

This command creates a binary file called change.log for tracking purposes.

  1. To disable change tracking, use this SQL statement:

SQL>ALTER DATABASE DISABLE BLCOK CHANGE TRACKING;

  1. To see whether change tracking is currently enabled, you can query from SQL*Plus, you can query V$BLOCK_CHAGNE_TRACKING.

SQL> SELECT filename,status FROM V$ BLOCK_CHAGNE_TRACKING;

Read more –>

Types of Recovery Manager Backups

Oracle database Hot Backups
Exports & Imports

Comments

comments

Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

Your email address will not be published. Required fields are marked *