ORACLE，SQL 查看 RMAN 进度

 查看 RMAN 进度

SELECT to_char(inst_id) inst,SID, SERIAL#,message, to_char(start_time,'yyyy-mm-dd HH24:MI:SS')  start_time, SOFAR, TOTALWORK, ceil(ELAPSED_SECONDS/60) ELAPSED_MI,
ROUND(SOFAR/TOTALWORK*100,2) "%COMPLETE",'alter system kill session '''||sid||','||serial#||',@'||INST_ID||''' immediate;' cmd FROM gV$SESSION_LONGOPS 
where opname like 'RMAN%' AND SOFAR <> TOTALWORK and  TOTALWORK<>0 order by start_time;

sql 查看 RMAN 配置

SELECT * FROM V$RMAN_CONFIGURATION;

查看当天 rman 记录

select sid,recid,stamp,command_id,operation,status,start_time,end_time,to_char(round(input_bytes/1024/1204,0)) input_MB,to_char(round(output_bytes/1024/1024,0)) output_MB,
object_type,output_device_type from (SELECT * FROM V$RMAN_STATUS order by command_id desc ) where start_time>TRUNC(SYSDATE)-1/86400 order by command_id;