RMAN restore status

Hello friends,

Below is the script for estimated time of Backup / Restore via RMAN:

col OPNAME for a28
select OPNAME,SOFAR/TOTALWORK*100 PCT, trunc(TIME_REMAINING/60) MIN_REMAINING,
trunc(ELAPSED_SECONDS/60) MIN_ELAPSED
from v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN%' order by 2;

Output as below:

Few more scripts below:

select sid, start_time, totalwork sofar, (sofar/totalwork) * 100 pct_done from
v$session_longops where totalwork > sofar AND opname NOT LIKE '%aggregate%' AND opname like 'RMAN%';

Output as below:

set lines 300
set pages 50
col client_info for a23
col event for a28
col spid for a5
select sid, spid, client_info, event, p1, p2, p3 from
v$process p, v$session s where p.addr = s.paddr and client_info like 'rman channel=%';

Output as below: