重庆思庄Oracle、Redhat认证学习论坛

标题: Oracle下启用块跟踪 [打印本页]

作者: jiawang 时间: 2022-11-23 17:10
标题: Oracle下启用块跟踪
创建存放块跟踪文件目录
[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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)