查看rman备份恢复进度

set line 200
col sid for 9999
col opname for a35

select inst_id,
sid,
serial#,
opname,
COMPLETE,
trunc(((to_char(last_update_time, 'dd') - to_char(start_time, 'dd')) * 60 * 24 +
(to_char(last_update_time, 'hh24') -
to_char(start_time, 'hh24')) * 60 +
(to_char(last_update_time, 'mi') - to_char(start_time, 'mi'))) * 100 /
complete) min
from (SELECT inst_id,
sid,
serial#,
opname,
ROUND(SOFAR / TOTALWORK * 100, 2) COMPLETE,
LAST_UPDATE_TIME,
START_TIME
FROM gV$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK);