Script to monitor RMAN progress

select  sid,  start_time,  totalwork
  sofar,  (sofar/totalwork) * 100 pct_done
from    gv$session_longops where
   totalwork > sofar AND    opname NOT LIKE '%aggregate%'
AND    opname like 'RMAN%';

Comments

Popular posts from this blog

Fatal agent error: Target Interaction Manager failed at Startup

[INS-40718] Single Client Access Name (SCAN): could not be resolved. ( LDOMS & Zones)

CRS-2883: Resource 'ora.asm' failed during Clusterware stack start