select b.name, a.status, a.time, round(b.bytes/(1024*1024),2) from v$backup a , v$datafile b where a.file# = b.file# and a.status != 'NOT ACTIVE' --select name from v$datafile