2012-11-22 - 11-23 11gR2 "Backup and Recovery User's Guide" page 395 - 424

 

Allocation of Input Disk Buffers -- INPUT BUFFER的分配

 

Monitoring RMAN Job Progress with V$SESSION_LONGOPS -- 通过此视图监控RMAN的JOB

 

To monitor RMAN job progress:

1. Before starting the RMAN job, create a script file (called, for this example,
longops) containing the following SQL statement: -- 先创建一个脚本记录以下SQL

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;

 

2. While the RMAN job is running, start SQL*Plus and connect to the target
database, and execute the longops script to check the progress of the RMAN job.
If you repeat the query while the RMAN job progresses, then you see output such
as the following: -- 当备份作业正在运行时 可以观察进度

 

SQL> @longops
SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
8 19 1 10377 36617 28.34
SQL> @longops
SID SERIAL# CONTEXT SOFAR TOTALWORK % COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
8 19 1 21513 36617 58.75

直到 没有没有显示（也就是RMAN作业已完成为止）