← Backup & Recovery
Oracle · Backup & Recovery

How to check RMAN backup elapsed times in Oracle

Show elapsed hours per Oracle RMAN backup job to track how long each run takes over time.

Tested on11g12c18c19c21c23ai26ai

Elapsed hours per RMAN backup job, ordered by session key. Compact form of V$RMAN_BACKUP_JOB_DETAILS — good for spotting a backup that suddenly takes twice as long as usual.

COL status FORMAT a9
COL hrs    FORMAT 999.99

SELECT session_key,
       input_type,
       status,
       TO_CHAR(start_time, 'mm/dd/yy hh24:mi') AS start_time,
       TO_CHAR(end_time,   'mm/dd/yy hh24:mi') AS end_time,
       elapsed_seconds / 3600 AS hrs
FROM   v$rman_backup_job_details
ORDER BY session_key;
rmanbackupelapsed time