← Backup & Recovery
Oracle · Backup & Recovery

How to check RMAN backup job history in Oracle

List Oracle RMAN backup jobs with status, input type, size, and time taken from V$RMAN_BACKUP_JOB_DETAILS.

Tested on11g12c18c19c21c23ai26ai

V$RMAN_BACKUP_JOB_DETAILS is Oracle''s own record of every RMAN backup run. This lists input type (DB FULL, ARCHIVELOG, INCR), status (COMPLETED, FAILED, RUNNING), device type, start and end times, output size, and total time taken.

SET LINESIZE 999 PAGESIZE 500
COL input_type           FORMAT a15
COL status               FORMAT a25
COL output_device_type   FORMAT a10
COL start_time           FORMAT a20
COL end_time             FORMAT a20
COL output_bytes_display FORMAT a10
COL time_taken_display   FORMAT a10

SELECT input_type,
       status,
       output_device_type,
       TO_CHAR(start_time, 'yyyy-mm-dd hh24:mi') AS start_time,
       TO_CHAR(end_time,   'yyyy-mm-dd hh24:mi') AS end_time,
       output_bytes_display,
       time_taken_display
FROM   v$rman_backup_job_details
ORDER BY session_key ASC;
rmanbackupv$rman_backup_job_details