可以查看rman备份进度的脚本

select s.inst_id, o.sid, CLIENT_INFO ch, context, sofar, totalwork,                    round(sofar/totalwork*100,2) "% Complete"     FROM gv$session_longops o, gv$session s     WHERE opname LIKE 'RMAN%'     AND opname NOT LIKE '%aggregate%'     AND o.sid=s.sid     AND totalwork != 0     AND sofar <> totalwork;