查看RMAN备份进度的两条SQL
近期在生产系统重新部署DG时网上收集发现如下两条SQL还是挺好用的，在此作为记录分享一下。<br />
SELECT SID,<br />
SERIAL#,<br />
CONTEXT,<br />
SOFAR,<br />
TOTALWORK,<br />
ROUND(SOFAR / TOTALWORK * 100, 2) "%_COMPLETE"<br />
FROM gV$SESSION_LONGOPS<br />
WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND<br />
TOTALWORK != 0 AND SOFAR <> TOTALWORK;<br />
<div style="white-space:nowrap;">
或<br />
<br />
<br />
col opname for a30<br />
set linesize 500 <br />
select inst_id,sid,serial#,opname,COMPLETE,<br />
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)/complete) min from <br />
( <br />
SELECT inst_id,<br />
sid,<br />
serial#,<br />
opname,<br />
ROUND(SOFAR / TOTALWORK * 100, 2) COMPLETE,<br />
LAST_UPDATE_TIME,<br />
START_TIME<br />
FROM gV$SESSION_LONGOPS<br />
WHERE OPNAME LIKE 'RMAN%'<br />
--AND OPNAME NOT LIKE '%aggregate%'<br />
AND TOTALWORK != 0<br />
AND SOFAR <> TOTALWORK<br />
) t ;<br />
<br />
<br />
如下为在系统查询的结果：<br />
<br />
SQL> SELECT SID,<br />
2 SERIAL#,<br />
3 CONTEXT,<br />
4 SOFAR,<br />
5 TOTALWORK,<br />
6 ROUND(SOFAR / TOTALWORK * 100, 2) "%_COMPLETE"<br />
7 FROM gV$SESSION_LONGOPS<br />
8 WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND<br />
9 TOTALWORK != 0 AND SOFAR <> TOTALWORK;<br />
<br />
<br />
SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
892 10655 1 23280622 53423998 43.58<br />
<br />
<br />
SQL> col opname for a30<br />
SQL> set linesize 500 <br />
SQL> <br />
SQL> select inst_id,sid,serial#,opname,COMPLETE,<br />
2 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)/complete) min from <br />
3 ( <br />
4 SELECT inst_id,<br />
5 sid,<br />
6 serial#,<br />
7 opname,<br />
8 ROUND(SOFAR / TOTALWORK * 100, 2) COMPLETE,<br />
9 LAST_UPDATE_TIME,<br />
10 START_TIME<br />
11 FROM gV$SESSION_LONGOPS<br />
12 WHERE OPNAME LIKE 'RMAN%'<br />
13 --AND OPNAME NOT LIKE '%aggregate%'<br />
14 AND TOTALWORK != 0<br />
15 AND SOFAR <> TOTALWORK<br />
16 ) t ;<br />
<br />
<br />
INST_ID SID SERIAL# OPNAME COMPLETE MIN<br />
---------- ---------- ---------- ------------------------------ ---------- ----------<br />
2 1057 37067 RMAN: aggregate input 78.34 139<br />
2 892 10655 RMAN: full datafile backup 43.65 156<br />
<br />
<br />
SQL> <br />
<br />
第二条SQL语句还显示剩余时间（估计时间）。<br />
</div>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31429259/viewspace-2154996/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
