This script will report on all backups – full, incremental and archivelog backups.
col STATUS format a9
col hrs format 999.99
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
--------------------------------------------------------------------------------------------------------------------------------
378 DB FULL RUNNING 02/25/15 08:10 02/25/15 10:15 2.08416
378 DB FULL COMPLETED 02/25/15 08:10 02/25/15 10:31 2.35944
386 BACKUPSET RUNNING 02/25/15 10:31 02/25/15 11:03 0.53305
386 BACKUPSET COMPLETED 02/25/15 10:31 02/25/15 11:20 0.81388
========================================================================================
Monitor RMAN Progress
select sid, start_time,totalwork, sofar, (sofar/totalwork) * 100 done,sysdate + time_remaining/3600/24 end_at from v$session_longops where totalwork > sofar AND opname NOT LIKE '%aggregate%' AND opname like 'RMAN%';
SID START_TIME TOTALWORK SOFAR DONE END_AT
-------------------------------------------------------------------------------------------------------------------------------------------------
511 25/02/2015 8:10:15 AM 32423936 29762040 91.79033 25/02/2015 10:20:14 AM
2306 25/02/2015 8:10:13 AM 34337280 32093688 93.46601 25/02/2015 10:17:55 AM
8 25/02/2015 8:10:13 AM 34207232 33463802 97.82668 25/02/2015 10:12:13 AM
========================================================================================
RMAN OS Process Details
set lines 120
column sid format 9999
column spid format 99999
column client_info format a25
column event format a30
column secs format 9999
select sid, spid, client_info, event, seconds_in_wait secs, p1, p2, p3 from v$process p, v$session s where p.addr = s.paddr and client_info like 'rman channel=%';
SID SPID CLIENT_INFO EVENT SECS P1 P2 P3
----------------------------------------------------------------------------------------------------------------------------------------------------
2306 8123 rman channel=c1 RMAN backup & recovery I/O 0 1 256 4294967
8 8130 rman channel=c2 RMAN backup & recovery I/O 0 1 256 4294967
113 8139 rman channel=c3 SQL*Net message from client 1949 1650815 1 0
208 8140 rman channel=c4 SQL*Net message from client 2539 1650815 1 0
405 8143 rman channel=c5 SQL*Net message from client 2633 1650815 1 0
511 8146 rman channel=c6 RMAN backup & recovery I/O 0 1 256 4294967