set lines 120
set pages 300
alter session set NLS_DATE_FORMAT="DD/MM/YYYY-HH24:MI:SS";
select start_time "Start", round(input_bytes/1024/1024*10)/10 "Source MB",
round(output_bytes/1024/1024*10)/10 "Backup MB", input_type "Type", status "Status",
round(elapsed_seconds/60*10)/10 "Duration (min)", round(COMPRESSION_RATIO*10)/10 "Ratio"
from v$rman_backup_job_details
where start_time >= SYSDATE-10 order by 1 desc;