Wednesday 8 July 2020

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;

No comments:

Post a Comment