RE: Rman Restore operaton
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: "'Jared Still'" <jkstill@xxxxxxxxx>
- Date: Wed, 22 Nov 2006 14:22:07 -0500
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:
