/*
 * OracleŽ Database Backup and Recovery Advanced User's Guide 10.2
 * Monitoring RMAN Through V$ Views 
 * 
 * metalink: Monitoring Recovery Manager Jobs [ID 144640.1] 
 */ 

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

-- rman channels
SELECT TO_CHAR(logon_time,'DD.MM.YYYY HH24:MI') logon_time, sid, spid, client_info FROM v$process p, v$session s 
WHERE p.addr = s.paddr 
AND client_info LIKE '%rman%';



-- rman session
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
/




-- ASYNC IO activity (arch backups)
set linesize 200
col filename for a50
select device_type "Device", type, filename, to_char(open_time, 'mm/dd/yyyy hh24:mi:ss') open,
       to_char(close_time,'mm/dd/yyyy hh24:mi:ss') close,elapsed_time ET, effective_bytes_per_second EPS
from v$backup_async_io
where TRUNC(open_time)=TRUNC(sysdate)
/

-- SYNC IO activity (db backups))
set linesize 200
col filename for a50
select device_type "Device", type, filename, to_char(open_time, 'mm/dd/yyyy hh24:mi:ss') open,
       to_char(close_time,'mm/dd/yyyy hh24:mi:ss') close,elapsed_time ET, effective_bytes_per_second EPS
from v$backup_sync_io
where TRUNC(open_time)=TRUNC(sysdate)
/