How to Enable and Disable Block Change Tracking

ENABLE

1. Verify BCT is disabled

   SELECT status FROM v$block_change_tracking;

2. Enable BCT with the database OPEN
   alter database enable block change tracking using file '+MY_FRA';
    Database altered.

3. Query BCT
    set lines 100
    col filename format a50
    col size_mb format 99,999
    select status,filename,bytes/1024/1024 size_mb from v$block_change_tracking;

    STATUS     FILENAME                                           SIZE_MB
    ---------- -------------------------------------------------- -------
    ENABLED    +MY_FRA/mydb/changetracking/ctf.6151.791995761        11

DISABLE

1. Verify BCT is enabled

   SELECT status FROM v$block_change_tracking;

2. Enable BCT with the database OPEN
   alter database disable block change tracking;
    Database altered.