******************************************************
* Description: SQL for Checking RMAN Restore Progress
* Compatiablity: RDBMS 10g, 11g, 12c
* Date: 18:03 PM EST, 01/16/2017
******************************************************


<1> Checking RMAN restore progress:
    |
    |__ SQL> SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" 
             FROM V$SESSION_LONGOPS WHERE OPNAME  LIKE '%RMAN%'AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;