查看RMAN备份进度的两条SQL
近期在生产系统重新部署DG时网上收集发现如下两条SQL还是挺好用的，在此作为记录分享一下。
SELECT SID,
SERIAL#,
CONTEXT,
SOFAR,
TOTALWORK,
ROUND(SOFAR / TOTALWORK * 100, 2) “%_COMPLETE”
FROM gV$SESSION_LONGOPS
WHERE OPNAME LIKE ‘RMAN%’ AND OPNAME NOT LIKE ‘%aggregate%’ AND
TOTALWORK != 0 AND SOFAR <> TOTALWORK;
2。
col opname for a30
set linesize 500
select inst_id,sid,serial#,opname,COMPLETE,
trunc(((to_char(last_update_time,’dd’)-to_char(start_time,’dd’))6024+(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)/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
) t ;