监控RMAN备份

1.设置COMMAND ID参数

run{

allocate channel c1 type disk;

  set command id to ‘rman’;

  backup datafile 5;

  release channel c1;

}

2.查询v$process和v$session哪些session对应到哪些channel

SELECT sid, spid, client_info

FROM v$process p, v$session s

WHERE p.addr = s.paddr

AND client_info LIKE '%id=rman%';

--------------------------------

SID,SPID,CLIENT_INFO

158,2380,id=rman

141,3924,id=rman,rman channel=c1

3.查询v$sesiion_longops以得到副本的状态

SELECT sid, serial#, context, sofar, totalwork,

round(sofar/totalwork*100,2) "% Complete"

FROM V$SESSION_LONGOPS

WHERE opname LIKE 'RMAN:%'

AND opname NOT LIKE 'RMAN: aggregate%'

AND totalwork != 0;

-------------------------------------

SID,SERIAL#,CONTEXT,SOFAR,TOTALWORK,%
Complete

159,6,1,58880,58880,100

159,6,2,37174,37174,100

145,1018,1,64000,64000,100

137,5,1,85879,85879,100

137,5,2,85881,85881,100

4.如果备份设备采用sbt，当拷贝进程显示挂起时，查询v$session_wait，使用第2步查询出的SID

SELECT * FROM V$SESSION_WAIT WHERE event LIKE '%sbt%' and SID=?;

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

转载于:http://blog.itpub.net/10314474/viewspace-622861/