How to check Rman backup Job

How to check Rman backup Job

 In below script we will see  RMAN backup status along with start and stop timing.

SQL> 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;  

SESSION_KEY INPUT_TYPE    STATUS    START_TIME     END_TIME           HRS
----------- ------------- --------- -------------- -------------- -------
      10476 DB INCR       COMPLETED 11/21/17 13:30 11/21/17 13:57     .44
      10491 DB INCR       COMPLETED 11/21/17 21:55 11/21/17 23:07    1.20
      10496 DB INCR       COMPLETED 11/22/17 06:00 11/22/17 06:07     .12
      10504 DB INCR       COMPLETED 11/22/17 21:55 11/22/17 23:02    1.13
      10509 DB INCR       COMPLETED 11/23/17 06:00 11/23/17 06:16     .26
      10517 DB INCR       COMPLETED 11/23/17 21:56 11/23/17 22:59    1.05
      10522 DB INCR       COMPLETED 11/24/17 06:00 11/24/17 06:04     .07
      10530 DB INCR       COMPLETED 11/24/17 22:06 11/24/17 23:10    1.06
      10535 DB INCR       COMPLETED 11/25/17 06:00 11/25/17 06:07     .11
      10543 DB INCR       COMPLETED 11/26/17 06:00 11/26/17 12:14    6.23
      10551 DB INCR       COMPLETED 11/27/17 06:00 11/27/17 07:20    1.34
      10559 DB INCR       COMPLETED 11/27/17 21:57 11/28/17 04:32    6.58
      10564 DB INCR       FAILED    11/28/17 06:00 11/28/17 12:49    6.81
      10568 DB INCR       COMPLETED 11/28/17 21:55 11/29/17 01:03    3.13
      10573 DB INCR       COMPLETED 11/29/17 06:00 11/29/17 06:25     .42
      10581 DB INCR       COMPLETED 11/29/17 21:48 11/29/17 23:34    1.77
      10586 DB INCR       COMPLETED 11/30/17 06:00 11/30/17 08:49    2.82
      10594 ARCHIVELOG    RUNNING   11/30/17 11:12 11/30/17 12:28    1.27

      10597 ARCHIVELOG    RUNNING   11/30/17 11:51 11/30/17 12:28     .61


In below script we will see  SID, Total Work, Sofar & % of completion.

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND (SOFAR/TOTALWORK*100, 2) "% COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%'

AND TOTALWORK! = 0 AND SOFAR <> TOTALWORK; 

       SID    SERIAL#    CONTEXT      SOFAR  TOTALWORK % COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
       111      22620          1     428855    3637560      11.79
       116        891          1     465662    1846176      25.22

        47        430          1   15747871   23353264      67.43

In this Script we will  check historical backup status with the help of following script:

 set linesize 500 pagesize 2000

 col Hours format 9999.99

 col STATUS format a10

 select SESSION_KEY, INPUT_TYPE, STATUS,

 to_char(START_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Bkup_start_time,

 to_char(END_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Bkup_end_time,

 elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS

 order by session_key;

SESSION_KEY INPUT_TYPE    STATUS     RMAN_BKUP_START_TIM RMAN_BKUP_END_TIME     HOURS

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

      10314 CONTROLFILE   COMPLETED  11-08-2017 06:05:22 11-08-2017 06:05:44      .01

      10322 DB INCR       COMPLETED  11-08-2017 21:59:32 11-08-2017 23:03:35     1.07

      10327 DB INCR       COMPLETED  11-09-2017 06:00:20 11-09-2017 06:04:58      .08

      10335 DB INCR       COMPLETED  11-09-2017 21:54:54 11-09-2017 22:58:09     1.05

      10340 DB INCR       COMPLETED  11-10-2017 06:00:21 11-10-2017 06:04:52      .08

      10348 DB INCR       COMPLETED  11-10-2017 21:56:20 11-10-2017 23:01:05     1.08

      10353 DB INCR       COMPLETED  11-11-2017 06:00:28 11-11-2017 06:06:38      .10

      10361 DB INCR       COMPLETED  11-12-2017 06:00:20 11-12-2017 06:33:49      .56

      10369 DB INCR       COMPLETED  11-13-2017 06:00:28 11-13-2017 06:06:47      .11

      10377 DB INCR       COMPLETED  11-13-2017 21:54:08 11-13-2017 23:10:10     1.27

      10382 DB INCR       COMPLETED  11-14-2017 06:00:20 11-14-2017 06:04:59      .08

      10390 DB INCR       COMPLETED  11-14-2017 22:01:09 11-14-2017 23:09:16     1.14

      10395 DB INCR       COMPLETED  11-15-2017 06:00:20 11-15-2017 06:07:13      .11

      10403 DB INCR       COMPLETED  11-15-2017 21:56:38 11-15-2017 23:00:32     1.07

      10408 DB INCR       COMPLETED  11-16-2017 06:00:20 11-16-2017 06:04:38      .07

      10416 DB INCR       COMPLETED  11-16-2017 21:55:53 11-16-2017 23:00:55     1.08

      10421 DB INCR       COMPLETED  11-17-2017 06:00:20 11-17-2017 06:05:43      .09

      10429 DB INCR       COMPLETED  11-17-2017 21:56:44 11-17-2017 23:01:21     1.08

      10434 DB INCR       COMPLETED  11-18-2017 06:00:29 11-18-2017 06:06:42      .10

      10442 DB INCR       COMPLETED  11-19-2017 06:00:20 11-19-2017 06:28:17      .47