Backup 진행상황 모니터링

[oracle@orcl ~]$ vi backupAll.rcv

run {

    set command id to 'r18';

    backup as compressed backupset database;

}

   

S SYS> ed rmanDoA

select sid,spid,client_info

from v$process p, v$session s

where p.addr = s.paddr

and client_info like '%id=&COMMAND_ID%'

/

   

S SYS> ed rmanProcess

select sid,serial#,context,sofar,totalwork,

    round(sofar/totalwork*100,2) "% Complete"

from v$session_longops

where opname like 'RMAN:%'

and opname not like 'RMAN: aggregate%'

and totalwork != 0

and sid=&SID            경우에 따라 &SID 대신 sid 값을 직접 입력해도 된다.

/

   

[oracle@orcl ~]$ rman target / cmdfile=backupAll.rcv log=backupAll.log

RMAN> 2> 3> 4> 5>

S SYS> @rmanDoA

Enter value for command_id: r18

       SID SPID         CLIENT_INFO

---------- ------------ ----------------------------------------------------------------

       128 2466         id=r18

S SYS> @rmanProcess         백업되는 상황의 Percentage 확인할 수 있다.

Enter value for sid: 128

       SID    SERIAL#    CONTEXT      SOFAR  TOTALWORK % Complete

---------- ---------- ---------- ---------- ---------- ----------

       128       2905          1     224480     224480        100

       128       2905          2     172147     172147        100