Scripts to check backup status and timings of database 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;

or can be restricted to report according to the concerned input_type :

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 hrsfrom V$RMAN_BACKUP_JOB_DETAILS

       where input_type='DB INCR' order by session_key;

-- or 'DB FULL'