oracle 查看 rman 备份

查看rman备份计划

select * from dba_scheduler_jobs;
desc DBA_SCHEDULER_JOB_RUN_DETAILS
SELECT a.job_name, start_date, end_date, status FROM DBA_SCHEDULER_JOBS a JOIN DBA_SCHEDULER_JOB_RUN_DETAILS b ON a.job_name = b.job_name 
WHERE b.owner = 'sys' AND job_type = 'PLSQL_BLOCK' AND job_action LIKE '%RMAN%';

查看rman进度

SELECT SID, SERIAL#,opname, 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" 
FROM V$SESSION_LONGOPS
where opname like 'RMAN%' AND SOFAR <> TOTALWORK and  TOTALWORK<>0 order by start_time asc;