Přikládám jen pár dotazů, pokud máte puštěnou obnovu nebo zálohu a nevíte, jak dlouho to asi poběží.

Hodí se to, když děláte večerní obnovu a rádi byste si aspoň na hodinku lehli, tak uvidíte, jestli úloha doběhne nebo to bude trvat déle.

SQL> SELECT sid, serial#, context, sofar, totalwork, round(sofar/totalwork*100,2) "% Complete"
 FROM v$session_longops
     WHERE opname LIKE 'RMAN%'
     AND opname NOT LIKE '%aggregate%'
     AND totalwork != 0
     AND sofar <> totalwork; 

       SID    SERIAL#    CONTEXT      SOFAR  TOTALWORK % Complete
---------- ---------- ---------- ---------- ---------- ----------
         4         49          1    2451170    6122880      40.03

SQL> COLUMN CLIENT_INFO FORMAT a30
COLUMN SID FORMAT 999
COLUMN SPID FORMAT 9999

SELECT s.SID, p.SPID, s.CLIENT_INFO
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
AND CLIENT_INFO LIKE 'rman%';

 SID SPID                     CLIENT_INFO
---- ------------------------ ------------------------------
   4 12817                    rman channel=ORA_DISK_1

SQL> col OPNAME for a30
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%';

OPNAME                                PCT MIN_RESTANTES MIN_ATEAGORA
------------------------------ ---------- ------------- ------------
RMAN: archived log backup             100             0            0
RMAN: archived log backup             100             0            0
RMAN: archived log backup             100             0            0
RMAN: archived log backup             100             0            0
RMAN: archived log backup             100             0            0
RMAN: archived log backup             100             0            0
RMAN: full datafile restore    94.8507728             8          158
RMAN: aggregate input                 100             0            0
RMAN: aggregate output                100             0            0
RMAN: aggregate output                100             0            0
RMAN: aggregate output                100             0            0

OPNAME                                PCT MIN_RESTANTES MIN_ATEAGORA
------------------------------ ---------- ------------- ------------
RMAN: aggregate input                 100             0            0


Komentáře