Cheeky Cockatoo

rem  Name	backup_mode.sql
rem  Purpose	Lists the backup status of all the datafiles

select substr(file_name,1,30),file#,b.status,time 
from v$backup b,dba_data_files f
where file#=file_id;