查看已经完成和未完成的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 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) "%COMPLETE",ceil(ELAPSED_SECONDS/60) ELAPSED_MI
FROM V$SESSION_LONGOPS
where 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 568005 568005 100 10
 1 7634 RMAN: incremental datafile backup 2016-05-06 23:00:03 91877 91877 100 6
 1 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
 1 7634 RMAN: archived log backup 2016-05-06 23:06:47 6167946 6167946 100 3
 1 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 226776 226776 100 7
 185 57618 RMAN: archived log backup 2016-05-07 23:06:47 8538 8538 100 1
 185 57618 RMAN: archived log backup 2016-05-07 23:06:47 8536 8536 100 1
 832 32639 RMAN: aggregate output 2016-05-07 23:07:13 20680 20680 100 0
 362 16579 RMAN: incremental datafile backup 2016-05-08 22:00:02 11284214 11284214 100 167
 2 62631 RMAN: incremental datafile backup 2016-05-08 22:00:02 226776 226776 100 166
 387 541 RMAN: aggregate input 2016-05-08 22:00:02 46328443 46328443 100 168
 2 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
---------- ---------- ----------------------------------- ------------------- ---------- ---------- ---------- ----------
 2 62631 RMAN: archived log backup 2016-05-09 00:46:58 490695 490695 100 1
 2 62631 RMAN: archived log backup 2016-05-09 00:46:58 490693 490693 100 1
 387 541 RMAN: aggregate output 2016-05-09 00:47:14 3026566 3026566 100 0
 387 541 RMAN: aggregate output 2016-05-09 00:47:17 3026566 3026566 100 0

26 rows selected.

SQL> 

查看未完成的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) "%COMPLETE",ceil(ELAPSED_SECONDS/60) ELAPSED_MI
FROM V$SESSION_LONGOPS
where opname like 'RMAN%' AND SOFAR <> TOTALWORK order by start_time asc;

这两个查询涉及到了一个动态性能视图v$session_longops，了解该视图的说明请参考我的另一篇文章：动态性能视图 V$SESSION_LONGOPS