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
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe