RMAN Info
Submitted by dave on Mon, 12/02/2013 - 11:16
Job Status
SELECT input_bytes_display, output_bytes_display, status, time_taken_display, det.* FROM V$RMAN_BACKUP_JOB_DETAILS det WHERE TRUNC(SYSDATE)=TRUNC(START_TIME) ORDER BY START_TIME DESC;
Viewing RMAN Job Status and Output
Job Throughput
How to measure the throughput of RMAN
RMAN Backup Async IO Rate
SELECT 'DUPLICATE/RESTORE THROUGHPUT', round(SUM(v.value/1024/1024),1) mbytes_sofar, round(SUM(v.value /1024/1024)/nvl((SELECT MIN(elapsed_seconds) FROM v$session_longops WHERE OPNAME LIKE 'RMAN: aggregate input' AND SOFAR != TOTALWORK AND elapsed_seconds IS NOT NULL ),SUM(v.value /1024/1024)),2) mbytes_per_sec, n.name FROM gv$sesstat v, v$statname n, gv$session s WHERE v.statistic#=n.statistic# AND n.name = 'physical write total bytes' AND v.sid = s.sid AND v.inst_id=s.inst_id AND s.program like 'rman@%' GROUP BY 'DUPLICATE/RESTORE THROUGHPUT',n.name;
How to measure throughput of RMAN
Articles
Cataloging and Uncataloging with RMAN
Archivelog Status
spool to log '/tmp/log.txt'; list backup of archivelog all; list archivelog all; spool log off;
RMAN Backup Size Query
set linesize200 set pagesize200 select name,open_mode from v$database; select sum(bytes)/1024/1024/1024 from dba_segments; SELECT completion_time , type, round(sum(bytes)/1048576) MB, round(sum(elapsed_seconds)/60) min FROM ( SELECT CASE WHEN s.backup_type='L' THEN 'ARCHIVELOG' WHEN s.controlfile_included='YES' THEN 'CONTROLFILE' WHEN s.backup_type='D' AND s.incremental_level=0 THEN 'LEVEL0' WHEN s.backup_type='I' AND s.incremental_level=1 THEN 'LEVEL1' END type, TRUNC(s.completion_time) completion_time, p.bytes, s.elapsed_seconds FROM v$backup_piece p, v$backup_set s WHERE p.status='A' and s.backup_type in ('D','I') AND p.recid=s.recid UNION ALL SELECT 'DATAFILECOPY' type, TRUNC(completion_time), output_bytes, 0 elapsed_seconds FROM v$backup_copy_details ) where completion_time > sysdate -15 group by completion_time, type order by 1 asc,2,3;