ZT 启用Block Change Tracking-10g新特性

最新推荐文章于 2019-09-11 17:43:16 发布

csdn_201601

最新推荐文章于 2019-09-11 17:43:16 发布

阅读量70

点赞数

Block chage tracking是Oracle10g的一个 新特性，Block change tracking进程记录自从上一次备份以来数据块的变化，并把这些信息记录在跟踪文件中。RMAN使用这个文件判断增量备份中需要备份的变更数据。这极大的促进了备份性能，RMAN可以不再扫描整个文件以查找变更数据。[@more@]

启用跟踪可以使用如下命令:


alter database enable block change tracking using
file '/data5/flash_recovery_area/EYGLE/eygle_block_track.log';

判断当前设置可以查询:


select filename,status,bytes from v$block_change_tracking;

关闭跟踪:


alter database disable block change tracking;

以下步骤供参考:


SYS AS SYSDBA on 29-MAR-05 >alter database enable block change tracking using
  2  file '/data5/flash_recovery_area/EYGLE/eygle_block_track.log';

Database altered.

SYS AS SYSDBA on 29-MAR-05 >select filename,status,bytes from v$block_change_tracking;

FILENAME
--------------------------------------------------------------------------------
STATUS          BYTES
---------- ----------
/data5/flash_recovery_area/EYGLE/eygle_block_track.log
ENABLED      11599872


SYS AS SYSDBA on 29-MAR-05 >alter database disable block change tracking;

Database altered.

SYS AS SYSDBA on 29-MAR-05 >select filename,status,bytes from v$block_change_tracking;

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

DISABLED

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/82387/viewspace-1016538/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/82387/viewspace-1016538/