| 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
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.
|
| |
| 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\product\flash_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%'; |
| |
| 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%'; |
|
