Script for RMAN restore current status

Below script to know RMAN restore current status and remaining time to complete the refresh.

Script:

set lines 199

select OPNAME,SOFAR/TOTALWORK*100 PCT, trunc(TIME_REMAINING/60) MIN_RESTANTES, 

trunc(ELAPSED_SECONDS/60) MIN_ATEAGORA 

from v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN%';

Output: