Sunday, 4 November 2012

RMAN Backup Progress



             Hi All, the belwo SQL query will help to identifiy the RMAN backup progress.

         SQL>SELECT SID, SERIAL#, CONTEXT,opname, 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
                 /

You need to run the above query at target database.

No comments:

Post a Comment