ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Monitoring RMAN Backups

Monitoring RMAN Backups

原创 Linux操作系统 作者:逍遥三人 时间:2012-02-19 18:39:53 0 删除 编辑
To correlate a process with a channel during a backup, perform. the following steps:
1. Start Recovery Manager and connect to the target database and, optionally, the recovery 
catalog.
2. Set the COMMAND ID parameter after allocating the channels and then copy the desired 
object. The string specified by the SET COMMAND ID command is entered into the 
V$SESSION.CLIENT_INFO column of all allocated channels. 
run {
allocate channel t1 type disk;
set command id to 'rman';
backup datafile 1;
release channel t1;}
3. Query the V$PROCESS and V$SESSION views to get the session identifier (SID) and the 
operating system process identifier (SPID) for the channels using the previously 
specified COMMAND ID string. 
SELECT sid, spid, client_info 
FROM v$process p, v$session s 
WHERE p.addr = s.paddr 
AND client_info LIKE '%id=rman%';
4. Query the V$SESSION_LONGOPS view to get the status of the copy.
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;
5. If you use a channel of type sbt and the copy process appears to hang, query 
V$SESSION_WAIT by using the SID obtained in step 3 to determine whether RMAN is 
waiting for a media manager function call to complete. 
SELECT * FROM V$SESSION_WAIT WHERE event LIKE '%sbt%';

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

请登录后发表评论 登录
全部评论

注册时间:2009-05-07

  • 博文量
    73
  • 访问量
    112156