Re: Rman Restore operaton
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: kennaim@xxxxxxxxx
- Date: Wed, 22 Nov 2006 11:14:32 -0800
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:
