Question: how to check if block change tracking is enabled?
Answer: SELECT status, filename FROM V$BLOCK_CHANGE_TRACKING; To enable block change tracking: Connect RMAN to the target database as described in "Connecting to the Target Database Using RMAN." In this example, the query results show that data files are stored in the file system in the directory /u01/app/oracle/oradata/orcl.