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

返回页首