RE: Rman Restore operaton

  • From: "Ken Naim" <kennaim@xxxxxxxxx>
  • To: "'Jared Still'" <jkstill@xxxxxxxxx>
  • Date: Wed, 22 Nov 2006 14:22:07 -0500


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?

        --,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: