Wednesday, May 14, 2014

Enable Block Change Tracking


1. Enable block change tracking

SQL> alter database enable block change tracking using file '+DATA';

Database altered.

2. Check the status of block change tracking

SQL> SELECT * FROM V$BLOCK_CHANGE_TRACKING;

STATUS
----------
FILENAME
--------------------------------------------------------------------------------
     BYTES
----------
ENABLED
+DATA/cvrman/changetracking/ctf.279.847591985
  11599872

No comments: