查看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;