The qbackup script will display the status, timing and size of the RMAN backups.
SQL
col STATUS format a9
col hrs format 999.99
col “Size” format a10
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,’dd/mm/yy hh24:mi’) start_time,
to_char(END_TIME,’dd/mm/yy hh24:mi’) end_time,
elapsed_seconds/3600 hrs,
OUTPUT_BYTES_DISPLAY “Size”
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;
Output