Home » RDBMS Server » Backup & Recovery » issue in Monitoring RMAN job Progress (multiple channels) (oracle 10.2.0.3 on AIX)
issue in Monitoring RMAN job Progress (multiple channels) [message #571339] Fri, 23 November 2012 08:09
sysdba007
Messages: 28
Registered: November 2012
Junior Member
Hi

I monitor progress of RMAN backup job using following query

howevrer the allocated channels after completing their bit again starts backing up new piece in the backup set

This is misleading to get the percentage completion of the job

could you please advise on this?


SELECT sum(work_done_percnt)/count(work_done_percnt) from(
	SELECT 	sl.sid, context, sofar, totalwork,client_info,
                    round(sofar/totalwork*100,2) work_done_percnt
     	FROM 	v$session_longops sl, v$session s
     	WHERE 	opname LIKE 'RMAN%'
     	AND 	opname NOT LIKE '%aggregate%'
     	AND 	sl.sid=s.sid
     	AND 	totalwork != 0
     	AND 	sofar <> totalwork);

SELECT 	sid, spid, client_info,status 
       	FROM 	v$process p, v$session s 
       	WHERE 	p.addr = s.paddr 
        AND 	client_info LIKE '%rman channel%';


Regards
sysdba007
Previous Topic: How to check for VSS support
Next Topic: Restore Backup File From Oracle 11g To Oracle 10 g
Goto Forum:
  


Current Time: Thu Jul 31 00:52:02 CDT 2014

Total time taken to generate the page: 0.08591 seconds