rman恢复进度的脚本

最新推荐文章于 2025-03-24 16:47:08 发布

bigclouder

最新推荐文章于 2025-03-24 16:47:08 发布

阅读量1.3k

点赞数

分类专栏： oracle 日常运维的各种脚本

本文链接：https://blog.youkuaiyun.com/kiwi_kid/article/details/41481775

版权

oracle 日常运维的各种脚本专栏收录该内容

51 篇文章

订阅专栏

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)/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;