While RMAN is running, you can monitor the progress of the operation by looking at V$SESSION_LONGOPS like this:
SQL> SELECT sid, serial#, context, sofar, totalwork, round(sofar/totalwork*100,2) "% Complete" 2 FROM v$session_longops 3 WHERE opname LIKE 'RMAN:%' 4 AND opname NOT LIKE 'RMAN: aggregate%';
Get more tips in minutes! Return to the main page.
About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.
IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.