Site icon DBA의 정석

rman 백업 시 진행률 확인



  1. 백업 수행


    1. rman target /

    2. backup database ;


   




  1. 진행률 확인



    1. 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 ;


         


Exit mobile version