Oracle - Script to monitor RMAN running backup

Script to monitor RMAN running backup.

col Timestarted format a16

set linesize 160

col opname for a18

select sid,opname,trunc((totalwork*8192)/1024/1024) "Total work(MB)",

trunc((sofar*8192)/1024/1024) "Work Done(MB)", to_char(start_time, 'MM-DD-YYYY HH24:MI:SSAM') "Timestarted", trunc(time_remaining/60) "Time remaining(min)",round(elapsed_seconds/60) "Time Elasped(min)", round(sofar/totalwork*100,2) "% Complete" from v$session_longops

where opname like 'RMAN%'

and totalwork != 0

and sofar != totalwork

order by start_time, totalwork desc

/

SQL> col Timestarted format a16

SQL> set linesize 160

SQL> col opname for a18

SQL> select sid,opname,trunc((totalwork*8192)/1024/1024) "Total work(MB)",

  2  trunc((sofar*8192)/1024/1024) "Work Done(MB)", to_char(start_time, 'MM-DD-YYYY HH24:MI:SSAM') "Timestarted", trunc(time_remaining/60) "Time remaining(min)",round(elapsed_seconds/60) "Time Elasped(min)", round(sofar/totalwork*100,2) "% Complete" from v$session_longops

  3  where opname like 'RMAN%'

  4  and totalwork != 0

  5  and sofar != totalwork

  6  order by start_time, totalwork desc

/

                                       Work Do                  Time rema   Time Elap

SID OPNAME             Total work(MB)  ne(MB)  Timestarted      ining(min)  sed(min) %Complete

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

522 RMAN: aggregate in       17886759  5031515 09-16-2017 18:00      1436     562      28.13

    put                                        :34PM

609 RMAN: incremental        10518528  2409091 09-16-2017 18:00      1893     562       22.9

    datafile backup                            :35PM

648 RMAN: incremental         3665920   645958 09-16-2017 18:00      2629     562      17.62

    datafile backup                            :35PM

698 RMAN: incremental         1413120   554313 09-16-2017 18:00       871     562      39.23

    datafile backup                            :35PM

739 RMAN: incremental         1402880   568512 09-16-2017 18:00       825     562      40.52

    datafile backup                            :35PM

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