Oracle Block Change Tracking
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Note: Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a block change tracking file using the CTW (Change Tracking Writer) process. During backups RMAN uses the log file to identify the specific blocks that must be backed up. This improves RMAN's performance as it does not have to scan whole datafiles to detect changed blocks. Logging of changed blocks is performed by the CTRW process which is also responsible for writing data to the block change tracking file.

You can only enable block change tracking at a physical standby database if a license for the Oracle Active Data Guard option has been purchased and this option is enabled. To enable Active Data Guard on a standby database, set the ENABLE_OPTION_ACTIVE_DATA_GUARD initialization parameter to TRUE. If a license for the Data Guard option has not been purchased, the ENABLE_OPTION_ACTIVE_DATA_GUARD initialization parameter should be set to FALSE. The open standby database will be closed, if recovery is started, and the following message is displayed in the alert log: You have note enabled the Active Data Guard option by setting ENABLE_OPTION_ACTIVE_DATA_GUARD to TRUE. The standby database will be closed before starting recover.
 
DISABLE
Disable block change tracking ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
conn / as sysdba

SELECT filename, status, bytes
FROM v$block_change_tracking;

ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;

SELECT filename, status, bytes
FROM v$block_change_tracking;

SELECT *
FROM gv$sgastat
WHERE name LIKE '%CTWR%';

SELECT inst_id, sid, program, status
FROM gv$session
WHERE program LIKE '%CTWR%';
 
ENABLE
Enable block change tracking ALTER DATABASE ENABLE BLOCK CHANGE TRACKING [USING FILE <file_path_and_name>] [REUSE];
conn / as sysdba

col filename format a60

SELECT filename, status, bytes
FROM v$block_change_tracking;

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE 'c:\oracle\fast_recovery_area\ORABASE\bctf01.log';

SELECT filename, status, bytes
FROM v$block_change_tracking;

SELECT *
FROM gv$sgastat
WHERE name LIKE '%CTWR%';

SELECT inst_id, sid, program, status
FROM gv$session
WHERE program LIKE '%CTWR%';

Related Topics
Backup Restore and Recover
CTWR Process
RMAN
RMAN Demos

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved