Block Change Tracking using Rman

Block Change Tracking

Block changing tracking improves the performance of incremental backups. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up.
You can Enable block change tracking when the database is either open or mounted. This section assumes that you intend to create the block change tracking file as an Oracle Managed File in the database area, which is where the database maintains active database files such as data files, control files, and online redo log files.

Block Change Tracking

SQL> select status from v$block_change_tracking;
STATUS                     FILENAME
----------                  --------------------  
DISABLED

SQL> select name from v$datafile;
NAME
------------------------------------------------------------------
/u01/app/oracle/oradata/TEST/system01.dbf
/u01/app/oracle/oradata/TEST/sysaux01.dbf
/u01/app/oracle/oradata/TEST/undotbs01.dbf
/u01/app/oracle/oradata/TEST/users01.dbf

DB_CREATE_FILE_DEST

Set the DB_CREATE_FILE_DEST  initialization parameter to specify the location where 
new database files, including the block change tracking file, must be stored.



SQL> alter system set  DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata';
System altered.

Enable Block Change Tracking for the database

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

Database altered.


SQL>  select status,filename from v$block_change_tracking;

STATUS     FILENAME
---------- ----------------------------------------
ENABLED    /u01/app/oracle/oradata/TEST/changetrack  ing/o1_mf_jl7qx7bp_.chg

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8