denrepo

OracleBackup & recovery

RMAN backup history with run time in hours

Run in the target database as SYSDBA, not the recovery catalog. The first report lists every RMAN job (full, incremental and archivelog) with start, end and hours taken. The second lists only incremental jobs (input type DB INCR).

Tested on 12c, 19c · verified Sep 2026

ora-rman-history.sql 
1-- Run in the database (not the catalog), logged in as SYSDBA.2CLEAR COLUMNS3SET LINESIZE 150 PAGESIZE 200 TRIMOUT ON TAB OFF4COLUMN STATUS FORMAT A95COLUMN hrs FORMAT 999.996 7-- All backups: full, incremental and archivelog8select9SESSION_KEY, INPUT_TYPE, STATUS,10to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,11to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,12elapsed_seconds/3600                   hrs13from V$RMAN_BACKUP_JOB_DETAILS14order by session_key;15 16-- Incremental backups only (input type DB INCR)17select18SESSION_KEY, INPUT_TYPE, STATUS,19to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,20to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,21elapsed_seconds/3600                   hrs22from V$RMAN_BACKUP_JOB_DETAILS23where input_type='DB INCR'24order by session_key;

Save it as ora-rman-history.sql and run it with SQL> @ora-rman-history.

Open in denrepoRelated tool: RMAN command builder

Helps with

More Oracle scripts: Backup & recovery