Monitor RMAN Backup

 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

/

REM RMAN Progress

alter session set nls_date_format='dd/mm/yy hh24:mi:ss'

/

select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,

sysdate + TIME_REMAINING/3600/24 end_at

from v$session_longops

where totalwork > sofar

AND opname NOT LIKE '%aggregate%'

AND opname like 'RMAN%'

/

REM RMAN wiats

set lines 120

column sid format 9999

column spid format 99999

column client_info format a25

column event format a30

column secs format 9999

SELECT SID, SPID, CLIENT_INFO, event, seconds_in_wait secs, p1, p2, p3

  FROM V$PROCESS p, V$SESSION s

  WHERE p.ADDR = s.PADDR

  and CLIENT_INFO like 'rman channel=%'

/