ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN: Checking the Progress of RMAN Backup/Recovery [ID 109159.1]

RMAN: Checking the Progress of RMAN Backup/Recovery [ID 109159.1]

原创 Linux操作系统 作者:spider0283 时间:2011-09-03 11:01:20 0 删除 编辑

修改时间 19-OCT-2010     类型 BULLETIN     状态 PUBLISHED 

PURPOSE
-------

This document shows how to check the progress of a backup/restore.

 
SCOPE & APPLICATION
-------------------

This note is applicable to all DBA's


How to check the progress of RMAN backup/recovery
--------------------------------------------------

To check the progress of a backup/restore, issue the following sql statement:

   select sid, serial#, context,
          round(sofar/totalwork*100,2) "% Complete",
          substr(to_char(sysdate,'yymmdd hh24:mi:ss'),1,15) "Time Now",
          elapsed_seconds
   from   v$session_longops
   where  compnam = 'dbms_backup_restore'; --> for 8.0

For Oracle8i and Oracle9i:

   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
   /



SID        SERIAL#    CONTEXT    % Complete Time Now        ELAPSED_SE
---------- ---------- ---------- ---------- --------------- ----------
12                               56         970408 14:21:07         30


You need to run this sql statement every 5 seconds to check if the 
% complete' or the 'elapsed_seconds' column is increasing in value.


If you suspect that RMAN is hanging then you can check the following:

1.  Check the media manager logs files for any problems with the backup or
    restore device.

2.  You can also check V$SESSION_WAIT to see what resources or events active 
    sessions are waiting for.

       Select * from v$session_wait where wait_time=0;

3.  You may also dump the process state for each process in the V$SESSION_WAIT 
    output, that is *NOT* waiting on: 'pmon timer', 'rdbms ipc message', 
    'smon timer' or 'client message'.

RELATED DOCUMENTS
-----------------

Oracle8/Oracle8i Server Reference
Oracle8 Server Backup and Recovery Guide
Oracle8i Recovery Manager User's Guide and Reference








显示相关信息 相关的


产品
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Standard Edition
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Personal Edition
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
PROGRESS

返回页首返回页首

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

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

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    628097