Monitor RMAN restore/recovery channels in progress.

[ SYS ] sql+> select banner from v$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

[ SYS ] sql+> set linesize 300

[ SYS ] sql+> select

l.sid,

l.start_time,

l.totalwork

sofar,

(l.sofar/l.totalwork) * 100 pct_done,

s.client_info

from v$session_longops l,

v$process p, v$session s

where l.totalwork > l.sofar

and l.opname not like '%aggregate%'

and l.opname like 'RMAN%'

and p.addr=s.paddr

and l.sid=s.sid;  

       SID START_TIM   SOFAR   PCT_DONE CLIENT_INFO

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

20 18-NOV-15 384000 45.3330729 rman channel=ORA_DISK_1

21 18-NOV-15 1792000 46.1713728 rman channel=ORA_DISK_2

22 18-NOV-15 1792000 51.7713728 rman channel=ORA_DISK_3

23 18-NOV-15 384000 86.3997396 rman channel=ORA_DISK_4

4 rows selected.

[ SYS ] sql+> /

       SID START_TIM   SOFAR   PCT_DONE CLIENT_INFO

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

20 18-NOV-15 384000 48.5330729 rman channel=ORA_DISK_1

21 18-NOV-15 1792000 46.8570871 rman channel=ORA_DISK_2

22 18-NOV-15 1792000 52.3428013 rman channel=ORA_DISK_3

23 18-NOV-15 384000 90.1330729 rman channel=ORA_DISK_4

4 rows selected.

[ SYS ] sql+> /

       SID START_TIM   SOFAR   PCT_DONE CLIENT_INFO

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

20 18-NOV-15 384000 51.7330729 rman channel=ORA_DISK_1

21 18-NOV-15 1792000 47.5428013 rman channel=ORA_DISK_2

22 18-NOV-15 1792000 53.0356585 rman channel=ORA_DISK_3

23 18-NOV-15 384000 93.3330729 rman channel=ORA_DISK_4

handy in a pinch when time is tight and your vp is watching over your shoulder...