查看RMAN备份恢复进度

查看RMAN恢复完成进度

SET line 200
col OPNAME FOR a30
col COMPLETE FOR a10

SELECT SID,
CASE
WHEN OPNAME LIKE '%aggregate%' THEN
'total'
ELSE
OPNAME
END OPNAME,
SOFAR,
TOTALWORK,
ROUND(SOFAR / TOTALWORK * 100, 2) || '%' "Complete"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN:%'
AND OPNAME NOT LIKE 'RMAN: aggregate%';


select sid,opname,serial#,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
order by "%_complete" desc

  SID OPNAME                                                              SERIAL#    CONTEXT      SOFAR  TOTALWORK %_complete
---------- ---------------------------------------------------------------- ---------- ---------- ---------- ---------- ----------
       201 RMAN: full datafile restore                                           36562          1   13593188   18566718      73.21
       393 RMAN: full datafile restore                                           22621          1   11283005   18429822      61.22
       394 RMAN: full datafile restore                                           30941          1    8834585   18430464      47.93
       580 RMAN: full datafile restore                                           45785          1    8666282   18426880      47.03