Monitoring RMAN Backups

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21584437/viewspace-716755/