This script will report on all backups – full, incremental and archivelog backups.
col STATUS format a9
col hrs format 999.99
select session_key, input_type, status,to_char(start_time,'mm/dd/yy hh24:mi') start_time,to_char(end_time,'mm/dd/yy hh24:mi') end_time,elapsed_seconds/3600 hrs from V$rman_backup_job_details order by session_key;
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
--------------------------------------------------------------------------------------------------------------------------------
378 DB FULL RUNNING 02/25/15 08:10 02/25/15 10:15 2.08416
378 DB FULL COMPLETED 02/25/15 08:10 02/25/15 10:31 2.35944
386 BACKUPSET RUNNING 02/25/15 10:31 02/25/15 11:03 0.53305
386 BACKUPSET COMPLETED 02/25/15 10:31 02/25/15 11:20 0.81388
========================================================================================