script to monitor the RMAN Running Jobs of the Oracle Database

Download  the script to find the RMAN running Jobs. HERE

[oracle@node1 script]$ more RMAN_JOB.sh
#!/bin/bash

clear scr
echo "***********************************************************"
echo "**************Monitoring RMAN Backup Jobs *****************"
echo "***********************************************************"


sqlplus -S / as sysdba@$1<<EOF


set line 300 pagesize 300
col ETA for a25
col OSPID for a5
SELECT S.SID AS "ORA_SID", P.SPID AS "OSPID",to_char(START_TIME,'Dy HH24:MI:SS') AS "START", L.TOTALWORK, L.SOFAR, ROUND(SOFAR/TOTALWORK*100,2) AS "%DONE", T
O_CHAR((SYSDATE + TIME_REMAINING/3600/24),'Dy HH24:MI:SS') AS "ETA"
FROM V\$SESSION_LONGOPS L, V\$SESSION S, V\$PROCESS P
WHERE S.PADDR=P.ADDR
AND S.SID=L.SID
AND TOTALWORK > SOFAR
AND OPNAME NOT LIKE '%aggregate%'
AND OPNAME LIKE '%RMAN%';

EOF

OUTPUT.

[oracle@node1 script]$ sh RMAN_JOB.sh node1

***********************************************************

**************Monitoring RMAN Backup Jobs *****************

***********************************************************

   ORA_SID OSPID START                  TOTALWORK      SOFAR      %DONE ETA

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

        33 6188  Fri 01:02:30             1735440      50096       2.89 Fri 01:07:43