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