Re: Rman Restore operaton

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 22 Nov 2006 11:14:32 -0800
Message-ID: <bf46380611221114o4bbd77a0pc02138c065e5cabd@mail.gmail.com>

On 11/22/06, Ken Naim <kennaim_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 22 2006 - 13:14:32 CST