Use the below query to monitor the currently running rman backup status.
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;
It shows a very detailed information. Thanks for sharing.
The below query also report the status of RMAN backup– Incremental, Full and Archivelog.
It is often require to monitor the status of the backup, and the below query will gives you the very clear picture of the backup status.
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;
Above query is really helpful otherwise it is difficult to trace RMAN the logs in case if we have not redirected output to a logfile.