← 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