select distinct(t.name), b.status from v$backup b, v$datafile d, v$tablespace t where d.ts# = t.ts# and d.file# = b.file# and b.status = 'ACTIVE';
exit