1:通过试图查找
SQL> select * from v$block_change_tracking;
STATUS FILENAME BYTES
---------- -------------------- ----------
DISABLED
2:启动功能,并指定文件
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING using file '/u01/bck';
Database altered.
3:确定生效
SQL> select * from v$block_change_tracking;
STATUS FILENAME BYTES
---------- -------------------- ----------
ENABLED /u01/bck 11599872
4:关闭功能
SQL> ALTER DATABASE disABLE BLOCK CHANGE TRACKING;
Database altered.
5:确定生效
SQL> select * from v$block_change_tracking;
STATUS FILENAME BYTES
---------- -------------------- ----------
DISABLED
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26655292/viewspace-744967/ ,如需转载,请注明出处,否则将追究法律责任。