This script will provide you to check the current running RMAN backup status and backup history whether its completed/running or failed with any issue.
set line 190
col STATUS format a30
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;
Sample Output-
![](https://usercontent.one/wp/www.oracleworlds.com/wp-content/uploads/2021/10/image-3.png)