RE: Rman Restore operaton

thanks
 
  _____  

From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: Wednesday, November 22, 2006 2:15 PM
To: kennaim@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Rman Restore operaton
 
On 11/22/06, Ken Naim <kennaim@xxxxxxxxx> wrote:
Is there a way to check how far along rman is during a restore (ow windods).
Seems like all the files et touched and windows shows the total file size
even if only 1% has been restored?

select
        sid
        ,serial#
        --,context -- what is this?
        --,units
        --,sofar 
        --,totalwork
        , &&blocksize * sofar bytes_sofar
        , &&blocksize * totalwork bytes_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
/

You'll find that in the documentation BTW.


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: