ITPub博客

首页 > 数据库 > Oracle > 开启和关闭block change track

开启和关闭block change track

原创 Oracle 作者:呱呱牛 时间:2016-02-24 09:38:09 0 删除 编辑
SQL> alter database enable block change tracking using file '/oracle/database/fast_recovery_area/INDSNM/indsnm_block_change_track.log';
Database altered.
SQL> 
SQL> select filename ,status, bytes from v$block_change_tracking;
FILENAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS                    BYTES
-------------------- ----------
/oracle/database/fast_recovery_area/INDSNM/indsnm_block_change_track.log
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

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

请登录后发表评论 登录
全部评论

注册时间:2014-05-29

  • 博文量
    96
  • 访问量
    209149