****************************************************** * 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;
Your Comments