Script to find the status of the RMAN backup from the command prompt

SQL> select start_time,end_time, status, input_type from v$rman_backup_job_details order by start_time;

START_TIM END_TIME  STATUS                  INPUT_TYPE
--------- --------- ----------------------- -------------
11-MAY-17 11-MAY-17 COMPLETED               RECVR AREA
11-MAY-17 11-MAY-17 COMPLETED               RECVR AREA
11-MAY-17 11-MAY-17 COMPLETED               RECVR AREA
11-MAY-17 11-MAY-17 COMPLETED               RECVR AREA
11-MAY-17 11-MAY-17 COMPLETED               RECVR AREA
11-MAY-17 11-MAY-17 COMPLETED               RECVR AREA
11-MAY-17 11-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               DB FULL
12-MAY-17 12-MAY-17 COMPLETED               DB FULL

START_TIM END_TIME  STATUS                  INPUT_TYPE
--------- --------- ----------------------- -------------
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
12-MAY-17 12-MAY-17 COMPLETED               RECVR AREA
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA
13-MAY-17 13-MAY-17 COMPLETED               DB FULL
13-MAY-17 13-MAY-17 COMPLETED               DB FULL
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA

START_TIM END_TIME  STATUS                  INPUT_TYPE
--------- --------- ----------------------- -------------
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA
13-MAY-17 13-MAY-17 COMPLETED               RECVR AREA
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA
14-MAY-17 14-MAY-17 COMPLETED               DB FULL
14-MAY-17 14-MAY-17 COMPLETED               DB FULL
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA

START_TIM END_TIME  STATUS                  INPUT_TYPE
--------- --------- ----------------------- -------------
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA
14-MAY-17 14-MAY-17 COMPLETED               RECVR AREA
15-MAY-17 15-MAY-17 COMPLETED               RECVR AREA
15-MAY-17 15-MAY-17 COMPLETED               RECVR AREA
15-MAY-17 15-MAY-17 COMPLETED               DB FULL
15-MAY-17 15-MAY-17 COMPLETED               DB FULL
15-MAY-17 15-MAY-17 COMPLETED               RECVR AREA
15-MAY-17 15-MAY-17 COMPLETED               RECVR AREA