創(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