Oracle下启用块跟踪

jiawang

创建存放块跟踪文件目录
[oracle@host01 ~]$ cd /u01/app
[oracle@host01 app]$ mkdir BCT

启用块跟踪
SQL> alter database enable block change tracking using file '/u01/app/BCT/rman.bct';


检查块跟踪状态
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