Backup Report from database side

Script to report on all backups - full, incremental and archivelog backups:

set linesize 2000

col STATUS format a9

col hrs format 999.99

select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs, STATUS from V$RMAN_BACKUP_JOB_DETAILS order by session_key;

Script to report on all backups - full, incrementals, not archivelog backups:

set linesize 2000

col STATUS format a9

col hrs format 999.99

select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs, STATUS from V$RMAN_BACKUP_JOB_DETAILS where input_type='DB INCR' order by session_key;

I] Script to report on all backupsets:

select decode(backup_type, 'L', 'Archive Log', 'D', 'Full', 'Incremental') backup_type,

incremental_level,

round(sum(original_input_bytes)/1024/1024,2) "MB in",

round(sum(output_bytes)/1024/1024,2) "MB out",

status,

min(start_time),

max(completion_time),

round((sum(output_bytes)/1024/1024)/((max(completion_time)-min(start_time))*86400), 1) "MB/s"

from v$backup_set_details

group by backup_type, incremental_level, status, session_key, session_recid, session_stamp

order by 6

/

II] Script to report on all backupsets:

 select ctime "Date"

 , decode(backup_type, 'L', 'Archive Log', 'D', 'Full', 'Incremental') backup_type

 , bsize "Size MB"

 from (select trunc(bp.completion_time) ctime

 , backup_type

 , round(sum(bp.bytes/1024/1024),2) bsize

 from v$backup_set bs, v$backup_piece bp

 where bs.set_stamp = bp.set_stamp

 and bs.set_count  = bp.set_count

 and bp.status = 'A'

 group by trunc(bp.completion_time), backup_type)

 order by 1, 2;