Articles Tagged: RMAN Backup history

~~~~~~~~~~~~~~~~~~~~~~~~ # RMAN backup history ~~~~~~~~~~~~~~~~~~~~~~~~ set lines 150 set pages 900 col start for a20 col end for a20 col status format a11 col input_bytes_display format a10 col output_bytes_display format a10 col status_weight format 99999 SELECT to_char(start_time,’YYYY.MM.DD HH24:MI:SS’) “Start” , to_char(end_time,’YYYY.MM.DD HH24:MI:SS’) “End”, status, status_weight, input_type, input_bytes_display, output_bytes_display FROM V$RMAN_BACKUP_JOB_DETAILS WHERE ( start_time between […]