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
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27039319/viewspace-1993471/