创建目录
[oracle@hu app]$ mkdir bct
[oracle@hu app]$ ll
total 16
drwxr-xr-x 2 oracle oinstall 4096 May 15 11:16 backup
drwxr-xr-x 2 oracle oinstall 4096 May 15 12:36 bct
drwxr-xr-x 8 oracle oinstall 4096 Apr 22 18:13 oracle
drwxrwx--- 5 oracle oinstall 4096 Apr 22 18:05 oraInventory
[oracle@hu app]$ cd bct/
[oracle@hu bct]$ pwd
/u01/app/bct
[oracle@hu bct]$
启动块跟踪
SQL> alter database enable block change tracking using file
2 '/u01/app/bct/rman.bct';

Database altered.
QL> !ls /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> !ls /u01/app/bct

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

FILENAME STATUS BYTES
---------------------- ---------- ----------
DISABLED

SQL>

ITPub博客

块跟踪

最新文章