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 Go to next message
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
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: 4579
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: Thu Mar 28 10:40:04 CDT 2024