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

最新推荐文章于 2014-06-12 19:40:57 发布

empoli

最新推荐文章于 2014-06-12 19:40:57 发布

阅读量322

点赞数

分类专栏： oracle everyday oracle official docs

本文链接：https://blog.csdn.net/empoli/article/details/8218317

版权

oracle everyday 同时被 2 个专栏收录

62 篇文章 0 订阅

订阅专栏

oracle official docs

59 篇文章 0 订阅

订阅专栏

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作业已完成为止）