查看已经完成和未完成的rman备份进度 set line 9999 col opname for a35 col start_time for a19 select sid , serial# , opname , to_char(start_time , 'yyyy - mm - dd hh24:mi:ss') start_time , sofar , totalwork , round(sofar/totalwork*100 , 2) %
查看已经完成和未完成的rman备份进度set line 9999col opname for a35col start_time for a19select sid, serial#,opname, to_char(start_time,'yyyy-mm-dd hh24:mi:ss') start_time, sofar, totalwork,round(sofar/totalwork*100,2) %complete,ceil(elapsed_seconds/60) elapsed_mifrom v$session_longopswhere opname like 'rman%' order by start_time asc; sid serial# opname start_time sofar totalwork %complete elapsed_mi---------- ---------- ----------------------------------- ------------------- ---------- ---------- ---------- ---------- 425 60361 rman: aggregate input 2016-05-06 23:00:00 56800564 56800564 100 10 164 7634 rman: incremental datafile backup 2016-05-06 23:00:03 91877 91877 100 6 164 7634 rman: incremental datafile backup 2016-05-06 23:00:03 22665768 22665768 100 6 873 12782 rman: aggregate output 2016-05-06 23:02:06 191157 191157 100 5 164 7634 rman: archived log backup 2016-05-06 23:06:47 6167946 6167946 100 3 164 7634 rman: archived log backup 2016-05-06 23:06:47 6167943 6167943 100 3 873 12782 rman: aggregate output 2016-05-06 23:08:43 11659959 11659959 100 1 425 60361 rman: aggregate output 2016-05-06 23:09:10 11659959 11659959 100 0 425 60361 rman: aggregate output 2016-05-06 23:09:10 11659959 11659959 100 0 832 32639 rman: aggregate input 2016-05-07 23:00:00 47200200 47200200 100 8 185 57618 rman: incremental datafile backup 2016-05-07 23:00:02 148787 148787 100 7 sid serial# opname start_time sofar totalwork %complete elapsed_mi---------- ---------- ----------------------------------- ------------------- ---------- ---------- ---------- ---------- 185 57618 rman: incremental datafile backup 2016-05-07 23:00:02 22664776 22664776 100 7 185 57618 rman: archived log backup 2016-05-07 23:06:47 889538 889538 100 1 185 57618 rman: archived log backup 2016-05-07 23:06:47 889536 889536 100 1 832 32639 rman: aggregate output 2016-05-07 23:07:13 2068890 2068890 100 0 362 16579 rman: incremental datafile backup 2016-05-08 22:00:02 11284214 11284214 100 167 264 62631 rman: incremental datafile backup 2016-05-08 22:00:02 22664776 22664776 100 166 387 54189 rman: aggregate input 2016-05-08 22:00:02 46328443 46328443 100 168 264 62631 rman: incremental datafile backup 2016-05-08 22:00:02 11246926 11246926 100 166 362 16579 rman: incremental datafile backup 2016-05-08 22:00:02 22665768 22665768 100 167 362 16579 rman: archived log backup 2016-05-09 00:46:58 505982 505982 100 1 362 16579 rman: archived log backup 2016-05-09 00:46:58 505984 505984 100 1 sid serial# opname start_time sofar totalwork %complete elapsed_mi---------- ---------- ----------------------------------- ------------------- ---------- ---------- ---------- ---------- 264 62631 rman: archived log backup 2016-05-09 00:46:58 490695 490695 100 1 264 62631 rman: archived log backup 2016-05-09 00:46:58 490693 490693 100 1 387 54189 rman: aggregate output 2016-05-09 00:47:14 3026566 3026566 100 0 387 54189 rman: aggregate output 2016-05-09 00:47:17 3026566 3026566 100 026 rows selected.sql>
查看未完成的rman备份进度set line 9999col opname for a35col start_time for a19select sid, serial#,opname, to_char(start_time,'yyyy-mm-dd hh24:mi:ss') start_time, sofar, totalwork,round(sofar/totalwork*100,2) %complete,ceil(elapsed_seconds/60) elapsed_mifrom v$session_longopswhere opname like 'rman%' and sofar totalwork order by start_time asc;
这两个查询涉及到了一个动态性能视图v$session_longops，了解该视图的说明请参考我的另一篇文章：动态性能视图 v$session_longops