Databases Reference
In-Depth Information
Reducing Incremental Backup Time
Problem
You want to reduce the time it takes to perform incremental backups.
Solution
Implement RMAN's block change tracking feature to reduce the time it takes to make an RMAN incremental backup.
By default, the block change tracking feature is disabled. Use the following command to create a change tracking file
in the specified location (if you leave out the location, RMAN creates the block change tracking file in the location
specified by the db_create_file_dest initialization parameter).
First, make sure the db_create_file_dest parameter is set. If it isn't, set it using the alter
system command, as shown in this example:
1.
SQL> alter system set
db_create_file_dest='/u01/app/oracle/dfiles'
scope= both;
Enable block change tracking by using the following alter database statement:
2.
RMAN> alter database enable block change tracking using file
'/u01/app/oracle/backup/change_track.f';
Statement processed
RMAN>
The name of the change tracking file is change_track.txt in our example.
You can disable block change tracking by using the following command:
RMAN> alter database disable block change tracking;
Statement processed
RMAN>
The change tracking file is automatically deleted when you execute the previous command.
How It Works
RMAN uses a binary file referred to as the block change tracking file to record the changed blocks in each data file in a
database. When you perform an incremental backup, RMAN refers to this change tracking file instead of scanning all
the data blocks in all the data files in the database, thus making the incremental backups finish faster. You can use the
alter database statement to change the name of the change tracking file.
The V$BLOCK_CHANGE_TRACKING view shows whether change tracking is enabled as well as other things
such as the change tracking file name.
 
Search WWH ::




Custom Search