Describe désert/Oracle/RMAN/Monitoring here.

Script to Monitor RMAN Backup Status and Timings

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
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

désert/Oracle/RMAN/Monitoring (last edited 2020-09-07 13:30:58 by 42)