块跟踪

创建目录
[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博客 ” ，链接：http://blog.itpub.net/31399171/viewspace-2139105/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31399171/viewspace-2139105/