RMAN restoration status monitoring

In most of cases, its difficult to guess "RMAN completion time" ( Backup/ Restore), below query will give estimate idea for your RMAN job,

Please note, query output will be based on "allocated channels" in RMAN backup jobs.

In enterprise edition, all channels will be allocated parallel, so you can see session for each channel.

But in Standard edition, though you have allocated multiple channels channels will be allocated serially, i.e one after other, hence in this edition you will see only one session for channel.


RMAN restoration status


SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
       ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE",time_remaining/60 "time_remaining"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
  AND OPNAME NOT LIKE '%aggregate%'
  AND TOTALWORK != 0
  AND SOFAR <> TOTALWORK
;

Please note: In restoration process, you will not get session through tns, you will have to take session from server itself.