A-A+

scripts:查看rman备份恢复进度

2013年01月17日 Tools&Scripts 暂无评论 阅读 1,987 次

查看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);

给我留言

Copyright © YallonKing 保留所有权利.   Theme  Ality

用户登录

分享到: