Check rman backup status

Full backup status:

set lines 200 pages 555

col START_TIME for a16

col END_TIME for a16

col INPUT_TYPE for a12

col  status for a12

col TIME_TAKEN_DISPLAY for a12

col INPUT_BYTES_DISPLAY for a12

col OUTPUT_BYTES_DISPLAY for a12

select start_time,end_time,output_device_type,input_type,status,time_taken_display,input_bytes_display,output_bytes_display from V$RMAN_BACKUP_JOB_DETAILS where input_type='DB FULL' order by start_time asc;

Incremental backup status:

select to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,

output_device_type,input_type,status,time_taken_display,input_bytes_display,output_bytes_display

 from V$RMAN_BACKUP_JOB_DETAILS where input_type='DB INCR' order by start_time asc;

Currently  running Incremental backup status:

select to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,

output_device_type,input_type,status,time_taken_display,input_bytes_display,output_bytes_display

 from V$RMAN_BACKUP_JOB_DETAILS where input_type='DB INCR' and  status='RUNNING' order by start_time asc;

Archive backup status:

select start_time,end_time,output_device_type,input_type,status,time_taken_display,

input_bytes_display,output_bytes_display from V$RMAN_BACKUP_JOB_DETAILS where input_type='ARCHIVELOG' order by start_time asc;

Currently  running archive backup status:

select to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,

output_device_type,input_type,status,time_taken_display,input_bytes_display,output_bytes_display

 from V$RMAN_BACKUP_JOB_DETAILS where input_type='ARCHIVELOG' and  status like '%RUNNING%' order by start_time asc;