Monitoring Rman

In this section i want to discuss how to monitor the RMAN sessions:

Query V$SESSION and V$PROCESS to identify the relationship between server sessions and RMAN

channels.

 COLUMN CLIENT_INFO FORMAT a30
 COLUMN SID FORMAT 999
 COLUMN SPID FORMAT 9999
 SELECT s.sid, p.spid, s.client_info,s.event
 FROM v$process p, v$session s
 WHERE p.addr = s.paddr
 AND CLIENT_INFO LIKE 'rman%';

We can Monitor the progress of backup and restore operations by querying V$SESSION_LONGOPS as shown below:

SQL> 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;
SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE
--- ------- ------- ------- --------- ----------
20  90       1      9470     15360   61.65
39  100      1      15871    28160   56.36

I wish those sample examples help you out.

Regards
Mohamed ELAzab