RMAN progress and what it is waiting for scripts

最新推荐文章于 2021-04-09 08:33:24 发布

转载最新推荐文章于 2021-04-09 08:33:24 发布 · 128 阅读

本文提供了一种使用SQL查询来监控RMAN备份进度的方法，通过查询v$session_longops及v$process视图获取当前RMAN操作的状态、剩余时间等详细信息。

Link From : http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=4688

REM RMAN Progress
alter session set nls_date_format='dd/mm/yy hh24:mi:ss'
/
select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
sysdate + TIME_REMAINING/3600/24 end_at
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%'
/

REM RMAN wiats
set lines 120
column sid format 9999
column spid format 99999
column client_info format a25
column event format a30
column secs format 9999
SELECT SID, SPID, CLIENT_INFO, event, seconds_in_wait secs, p1, p2, p3
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
and CLIENT_INFO like 'rman channel=%'

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1003694/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1003694/