set lines 190
col file_name for a60
col tablespace_name for a30
 
select df.file_name,
       tablespace_name,
       b.change#,
       to_char(b.time, 'dd/mm/yyyy hh24:mi') TIME,
       b.status
  from v$backup b, dba_data_files df
 where b.status <> 'NOT ACTIVE'
   and b.file# = df.file_id;