MONITORING RMAN BACKUPS

SQL> SELECT sid, serial#, sofar, totalwork, opname, round(sofar/totalwork*100,2) A
          FROM v$session_longops  WHERE opname LIKE 'RMAN%'
         AND opname NOT LIKE '%aggregate%' AND totalwork != 0
         AND sofar <> totalwork;

       SID    SERIAL#      SOFAR  TOTALWORK      OPNAME               PCT_COMPLETE
---------- ---------- ---------- ---------- --------------- ------------------------------------------------
       135          7          507382       6230432        RMAN: full data         8.14        file backup



Happy Learning...