Status information for jobs in progress and completed jobs is stored in V$RMAN_STATUS. V$RMAN_OUTPUT contains the text ouptut of all RMAN jobs.

To see status information on jobs in V$RMAN_STATUS use the following query:

SQL>SELECT OPERATION,STATUS,MBYTES_PROCESSED,START_TIME,END_TIME FROM V$RMAN_STATUS;

To correlate a channel with a process, run the following query in SQL*Plus while the RMAN job is executing:

SQL>COLUMN CLIENT_INFO FORMAT a30 
SQL>COLUMN SID FORMAT 999
SQL>COLUMN SPID FORMAT 9999
SQL>SELECT s.SID, p.SPID, s.CLIENT_INFO 
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
AND CLIENT_INFO LIKE'rman%';

To calculate the progress of an RMAN job, run the following query in SQL*Plus while the RMAN job is executing:

SQL>SELECT SID, SERIAL#, CONTEXT, SOFAR, 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;
Go to top
JSN Boot template designed by JoomlaShine.com