Oracle RMAN Full and Archive backup.

For RMAN Archive Backup

SET PAGES 999 LINES 999
COL STATUS FORMAT A9
COL "HRS" FORMAT 999.99
COL "MIN" FORMAT 99999.99
COL HOST_NAME FOR A10;
SELECT NAME,INSTANCE_NAME,HOST_NAME,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",
ELAPSED_SECONDS/60 "MIN"
FROM V$RMAN_BACKUP_JOB_DETAILS,
(SELECT NAME FROM V$DATABASE),
(SELECT INSTANCE_NAME,SUBSTR(HOST_NAME,1,10) "HOST_NAME" FROM GV$INSTANCE)
WHERE INPUT_TYPE='ARCHIVELOG'
ORDER BY SESSION_KEY;

 

For RMAN Full backup 

SET PAGES 999 LINES 999
COL STATUS FORMAT A9
COL "HRS" FORMAT 999.99
COL "MIN" FORMAT 99999.99
COL HOST_NAME FOR A10;
SELECT NAME,INSTANCE_NAME,HOST_NAME,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",
ELAPSED_SECONDS/60 "MIN"
FROM V$RMAN_BACKUP_JOB_DETAILS,
(SELECT NAME FROM V$DATABASE),
(SELECT INSTANCE_NAME,SUBSTR(HOST_NAME,1,10) "HOST_NAME" FROM GV$INSTANCE)
WHERE INPUT_TYPE NOT IN ('ARCHIVELOG')
ORDER BY SESSION_KEY;