Block Change Tracking for Incremental Backups in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 25th, 2018
Block Change Tracking for Incremental Backups in Oracle database 11gR2
The Block change tracking is mainly used in Incremental backup of the database as it has to scan each block of the datafile to find weather it has any changes or not & it also consume more time, to reduce this we can enable the block change tracking in database level
When you enable this, the file will maintain the status of blocks whether changes or not while taking the RMAN Incremental backup & RMAN will scan this file instead of whole datafile to find the which blocks are changed & it’s a faster operation to perform the incremental backup
To enable block change tracking in database
[oracle@ogg-test1 ~]$ !sq sqlplus SQL*Plus: Release 11.2.0.4.0 Production on Sat Feb 24 18:15:12 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options sys@TESTDB>
sys@TESTDB> select INSTANCE_NAME,VERSION from v$instance; INSTANCE_NAME VERSION ---------------- ----------------- testdb 11.2.0.4.0
Enable the block change tracking in your specified location
SQL> alter database enable block change tracking using file ‘/u01/app/oracle/fast_recovery_area/test_db_bct.f' reuse;
Get the status:
sys@TESTDB> SELECT STATUS, FILENAME FROM V$BLOCK_CHANGE_TRACKING; STATUS FILENAME ------------------------------------------------------ ENABLED /u01/app/oracle/fast_recovery_area/test_db_bct.f
Disabling Block Change Tracking
sys@TESTDB> alter database disable block change tracking; Database altered.
=====Hence tested & verified in our env=====