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

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%';

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

Current Time: Wed Aug 27 06:14:55 CDT 2014

Total time taken to generate the page: 0.18156 seconds