CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle BLOCK CHANGE TRACKING
Version 11.1
 
General
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. 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 CTWR process which is also responsible for writing data to the block change tracking file.
 
ENABLE
Enable block change tracking conn / as sysdba

set linesize 121
col filename format a60

SELECT filename, status, bytes
FROM v$block_change_tracking;

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

SELECT filename, status, bytes
FROM v$block_change_tracking;
 
DISABLE
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;
 
Related Topics
RMAN
RMAN Demos
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [57 users online]    © 2010 psoug.org