oracle hotbackup check

set line 200
col name for a50
col status for a15
select a.file#,a.name,b.status,to_char(b.time,'YYYY-MM-DD:HH24:MI:SS') as time
from v$datafile a,v$backup b
where a.file#=b.file#;


SQL> @hot

     FILE# NAME                                               STATUS          TIME
---------- -------------------------------------------------- --------------- -------------------
         1 /oracle/app/oracle/oradata/CHANGE19/system01.dbf   NOT ACTIVE
         3 /oracle/app/oracle/oradata/CHANGE19/sysaux01.dbf   NOT ACTIVE
         4 /oracle/app/oracle/oradata/CHANGE19/undotbs01.dbf  NOT ACTIVE
         7 /oracle/app/oracle/oradata/CHANGE19/users01.dbf    NOT ACTIVE