Query To Find RMAN Backup Status

Description:-

In this article we are going to see the below query to check rman backup status.

Demo:-

Query to check rman backup status:-

col STATUS format a10
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;

Output