block change tracking to speeds up the incremntal backup

This parameter is new in 10g and it enables fast incremental backup

Oracle need not to scan all the database block for change as if this parameter is enable
it contains all the information of changed blocks ,so it speeds up the incremental backup.


to check whether this parameter is enables or not


SQL> select * from v$block_change_tracking;

to enable it use following

SQL> alter database enable block change tracking using file 'e:\file.txt';

Database altered.