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 Go to next message
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%';

Re: issue in Monitoring RMAN job Progress (multiple channels) [message #650458 is a reply to message #571339] Mon, 25 April 2016 14:44 Go to previous message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
See Monitor RMAN restore.
Previous Topic: How long can we keep backed up files in RMAN NOCATALOG?
Next Topic: What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set
Goto Forum:

Current Time: Wed Aug 10 04:00:57 CDT 2022