Rman_backup_restore_progress.sql

----To Check Backup Progress and Restore Progress
set lines 9999

 SELECT SID, SERIAL#,OPNAME, 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

------To Check Backup Progress and Restore Progress
set lines 9999
col FILENAME for a60
select SID,STATUS,open_time, BYTES/1024/1024/1024 "SOFAR GB" ,total_bytes/1024/1024/1024 TotMb, round(BYTES/TOTAL_BYTES*100,2) "% Complete" , filename from v$backup_async_io where STATUS != 'FINISHED';