Мониторинг рман

REM RMAN Progress

alter session set nls_date_format='dd/mm/yy hh24:mi:ss'
/


select SID, START_TIME,TOTALWORK, sofar
, (sofar/totalwork) * 100 done
, sysdate + TIME_REMAINING/3600/24 end_at 
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%' 
/
взято здесь