select a.name, a.status , b.status "status bkp", a.bytes from v$datafile a, v$backup b
where a.file# = b.file# order by b.status;

hostgator