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?

       --,context -- what is this?
       , &&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: