First page Back Continue Last page Graphics

Checking RMAN Progress


Notes:

RMAN reports its activity to the V$SESSION_LONGOPS view. Therefore we can query this view to determine the status of a job and also determine if a job is hung (perhaps waiting for a tape mount). The example shown above displays activity that is not complete (sofar <> totalwork). It also shows the LAST_UPDATE. If a job is taking longer than you think it should, query again after a couple of minutes. If the SOFAR value or the LAST_UPDATE value has not changed, try to find a reason that the session is hung. The V$SESSION_WAIT view can assist here (though it will not show a tape media manager event).
A more detailed version of this query – including a query of V$SESSION_WAIT – is supplied in the script file v$session_longops.sql.