創(chuàng)建存放塊跟蹤文件目錄
[oracle@host01 ~]$ cd /u01/app
[oracle@host01 app]$ mkdir BCT

啟用塊跟蹤
SQL> alter database enable block change tracking using file '/u01/app/BCT/rman.bct';


檢查塊跟蹤狀態(tài)
SQL> col filename for a22

SQL> select filename, status, bytes from v$block_change_tracking；
FILENAME STATUS BYTES

---------------------- ---------- ----------

/u01/app/BCT/rman.bct ENABLED 11599872





停用塊跟蹤
SQL> alter database disable block change tracking;
Database altered.


SQL> select filename,status,bytes from v$block_change_tracking;

FILENAME? ?? ?? ?? ?? ???STATUS? ?? ?BYTES

------------------- ---------- ----------

? ?? ?? ?? ???DISABLED