工作中,在执行rman备份与恢复时,如果窗口不小心关闭了,或者断开了,如何查看rman备份与恢复得得进度。
查看RMAN备份进度(全量备份与增量备份)
SELECT sid, serial#, CONTEXT, message, sofar, totalwork, round(sofar / totalwork * 100,2) "%_COMPLETE" FROM gv$session_longops WHERE opname LIKE 'RMAN%' AND opname NOT LIKE '%aggregate%' AND totalwork != 0 AND sofar <> totalwork;
查看RMAN恢复进度
SELECT sid, serial#, CONTEXT, message, sofar, totalwork, round(sofar / totalwork * 100,2) "%_COMPLETE" FROM gv$session_longops WHERE opname LIKE 'RMAN%' AND opname NOT LIKE '%aggregate%' AND totalwork != 0 AND sofar <> totalwork;
