Check RMAN Backup Status

There is a very good script shared by one of the famous DBA "Gavin Soorma" on his site whic is related to Rman Backup status .I am sharing the same script here . Here is the link :


http://gavinsoorma.com/2009/07/rman-script-to-check-backups/comment-page-1/
This script will report on all backups – full, incremental and archivelog backups .

SQL> 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 ;

This script will report all on full and incremental backups, not archivelog backups -
SQL> 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
where input_type='DB INCR' 
order by session_key ;

Enjoy    :-)