Oracle - List completed RMAN backup timings

Script to list completed RMAN backup timings.

col STATUS format a24

col min format 99999.99

col START_TIME for a20

col END_TIME for a20

set pages 99 linesize 235

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/60 min from V$RMAN_BACKUP_JOB_DETAILS

order by session_key;

SQL> col STATUS format a24

SQL> col min format 99999.99

col START_TIME for a20

SQL> SQL> col END_TIME for a20

SQL> set pages 99 linesize 235

SQL> select SESSION_KEY, INPUT_TYPE, STATUS,

  2  to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,

  3  to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,

  4  elapsed_seconds/60 min from V$RMAN_BACKUP_JOB_DETAILS

  5  order by session_key;

SE_KEY INPUT_TYPE    STATUS                   START_TIME      END_TIME             MIN

------ ------------- ------------------------ --------------- ------------------------

 10364 ARCHIVELOG    COMPLETED                09/09/17 08:01  09/09/17 09:01     59.52

 10367 ARCHIVELOG    COMPLETED                09/09/17 13:02  09/09/17 13:46     43.73

 10370 ARCHIVELOG    COMPLETED                09/09/17 16:02  09/09/17 16:24     22.18

 10373 DB INCR       COMPLETED                09/09/17 18:00  09/10/17 22:30   1709.50

 10375 ARCHIVELOG    COMPLETED                09/09/17 22:02  09/09/17 23:58    115.65

 10378 ARCHIVELOG    COMPLETED                09/10/17 01:04  09/10/17 01:37     33.20

 10381 ARCHIVELOG    COMPLETED WITH ERRORS    09/10/17 04:02  09/10/17 05:33     91.12

 10384 ARCHIVELOG    COMPLETED                09/10/17 08:02  09/10/17 09:42    100.20

 10387 ARCHIVELOG    COMPLETED                09/10/17 13:02  09/10/17 14:02     59.93

 10390 ARCHIVELOG    COMPLETED                09/10/17 16:01  09/10/17 16:34     32.80

 10393 ARCHIVELOG    COMPLETED                09/10/17 22:01  09/10/17 22:42     40.88

 10398 ARCHIVELOG    COMPLETED                09/11/17 01:02  09/11/17 01:20     18.62

 10410 ARCHIVELOG    COMPLETED                09/11/17 16:01  09/11/17 16:07      6.43

 10413 ARCHIVELOG    COMPLETED                09/11/17 22:02  09/11/17 22:17     15.45

 10416 ARCHIVELOG    COMPLETED                09/12/17 01:01  09/12/17 01:10      8.10

 10419 ARCHIVELOG    COMPLETED                09/12/17 04:01  09/12/17 04:41     39.83

 10431 ARCHIVELOG    COMPLETED                09/12/17 22:02  09/12/17 22:20     18.65

 10434 ARCHIVELOG    COMPLETED                09/13/17 01:01  09/13/17 01:15     13.43

 10437 ARCHIVELOG    COMPLETED                09/13/17 04:01  09/13/17 04:41     39.93

 10440 ARCHIVELOG    COMPLETED                09/13/17 08:01  09/13/17 08:55     53.37

 10452 ARCHIVELOG    COMPLETED                09/14/17 01:02  09/14/17 01:15     13.22

 10455 ARCHIVELOG    COMPLETED                09/14/17 04:01  09/14/17 04:44     42.13

 10458 ARCHIVELOG    COMPLETED WITH ERRORS    09/14/17 08:01  09/14/17 09:03     62.17

 10461 ARCHIVELOG    COMPLETED                09/14/17 13:01  09/14/17 13:27     26.05

 10470 ARCHIVELOG    COMPLETED                09/15/17 01:01  09/15/17 01:08      7.12

 10497 ARCHIVELOG    COMPLETED                09/16/17 13:02  09/16/17 13:47     44.72

 10505 ARCHIVELOG    COMPLETED                09/16/17 22:02  09/16/17 23:43    100.82

 10508 ARCHIVELOG    COMPLETED                09/17/17 01:03  09/17/17 01:31     28.33