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/