gistfile1.txt

% sqlplus -S / as sysdba
set lines 9999
select open_mode from v$database;

OPEN_MODE
------------------------------------------------------------
MOUNTED

select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
sysdate + TIME_REMAINING/3600/24 end_at
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%';

       SID START_TIME           TOTALWORK      SOFAR       DONE END_AT
---------- ------------------- ---------- ---------- ---------- -------------------
         2 2015-09-16 15:44:56   50521344   15788016   31.25019 2015-09-16 18:04:32

quit