To find running RMAN Jobs

During Backup / Restore, to check the background running RMAN jobs in sql prompts:


col message for a60

set linesize 1000
SELECT SID, SERIAL#, CONTEXT, SOFAR, message,
TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2)
FROM V$SESSION_LONGOPS
WHERE ROUND(SOFAR/TOTALWORK*100) !=100
AND OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;

 ----------------------------------------------------

select sid, start_time, totalwork sofar, (sofar/totalwork) * 100 pct_done from v$session_longops where
totalwork > sofar AND opname NOT LIKE '%aggregate%' AND  opname like 'RMAN%';


-----------------------------------------------------------------------------
 
select sid, spid, client_info, event, seconds_in_wait, p1, p2, p3 from v$process p, v$session s where p.addr = s.paddr and client_info like 'rman channel=%';