1
Mar

Monitoring RMAN backup

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

Back to Top