DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, February 9, 2016

Block change tracking for faster Incremental RMAN backups


The details of changes in the blocks of the database after the last backup are written in the block change tracking file.RMAN uses this file for tracking the changed block and backup it instead all the blocks and hence saves time and space.

The background process Block Change Tracking Writer (CTWR) will be writing modified block details to block change tracking file.

The Change Tracking file is read during backups and the required blocks are accessed directly.

To enable block change tracking 

alter database enable block change tracking using file '/u02/oracle/oradata/GOLD/block_change_track.dbf';

when using OMF we can enable block change tracking as follows

alter database enable block change tracking ;

the change tracking file will be created in the directory mentioned by DB_CREATE_FILE_DEST.


now check ,

col filename for a70
select filename,status from v$block_change_tracking;

FILENAME STATUS
-----------------------------------                          ---------------
'/u02/oracle/oradata/GOLD/block_change_track.dbf'
ENABLED


To Disable
-----------------------

SQL>alter database disable block change tracking;


To Check
-----------------------

select status from V$BLOCK_CHANGE_TRACKING;

1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.