Query to check RMAN BACKUP History

SQL Query to know the history of RMAN Backup

Useful sql query to know about the RMAN Backup history along with TOTAL_GB_BACKEDUP , STATUS, TIME_TAKEN_HOURS etc.

alter session set optimizer_mode=Rule;

set linesize 200

col TAG format a19

col TIME_TAKEN_hours format a16

col total_gb_backedup format a20

col status format a10

col read_mb_per_sec format a10

col write_mb_per_sec format a10

col input_type format a12

select COMMAND_ID Tag,OUTPUT_BYTES_DISPLAY total_gb_backedup, status,INPUT_TYPE,TIME_TAKEN_DISPLAY TIME_TAKEN_hours,

INPUT_BYTES_PER_SEC_DISPLAY read_mb_per_sec ,OUTPUT_BYTES_PER_SEC_DISPLAY write_mb_per_sec from V$RMAN_BACKUP_JOB_DETAILS where INPUT_TYPE='DB FULL' and STATUS like '%COMPLETED%' order by Tag;

Output

Please like and share if you find this blogpost useful.