RMAN Progress Monitor (rman_progress.sql)

What This Script Does

This script monitors the progress of RMAN backup and restore operations across all RAC instances, showing start time, total work, completion percentage, blocks per second rate, and estimated completion time. Essential for tracking long-running RMAN operations and estimating completion times.

The Script

select inst_id ,SID, START_TIME,TOTALWORK,
 (sofar/decode(elapsed_seconds,0,1,elapsed_seconds))* value bps,
 sofar, (sofar/decode(totalwork,0,1,totalwork)) * 100 done,
 sysdate + TIME_REMAINING/3600/24 end_at
 from gv$session_longops a, v$parameter
 where totalwork > sofar
 AND opname like 'RMAN%'
 and name  = 'db_block_size'
 order by start_time;

Parameters

The script prompts for:

None - this script requires no parameters

Usage

-- Basic usage
@rman_progress.sql

Sample Output

   INST_ID        SID START_TIME            TOTALWORK         BPS      SOFAR       DONE END_AT
---------- ---------- -------------------- ---------- ----------- ---------- ---------- --------------------
         1        123 05-JAN-25 14:30:15      500000      1250.5     125000         25 05-JAN-25 16:30:15
         1        124 05-JAN-25 14:35:20      750000      1875.2     375000         50 05-JAN-25 15:45:30
         2        156 05-JAN-25 14:40:10      300000       950.8      90000         30 05-JAN-25 15:20:45