Oracle 有哪些表和视图可以用于备份恢复异常时性能诊断？

v$rman_status、v$rman_backup_job_details

select s.status as \"备份状态\",

       b.INPUT_TYPE as \"备份类型\",

       to_char(b.START_TIME,\'yyyy-mm-dd hh24:mi:ss\') as 总的开始时间,

       to_char(b.end_time, \'yyyy-mm-dd hh24:mi:ss\') as 总的结束时间,

       trunc(b.ELAPSED_SECONDS/60,0) as 耗时多少分钟,

       b.INPUT_BYTES_PER_SEC_DISPLAY \"in_sec/s\",

       b.OUTPUT_BYTES_PER_SEC_DISPLAY \"out_sec/s\",

       trunc((s.END_TIME-s.START_TIME)*24*60,0) \"单个文件备份用时(分)\",

       to_char(s.START_TIME, \'yyyy-mm-dd hh24:mi:ss\') as \"开始备份时间\",

       to_char(s.END_TIME, \'yyyy-mm-dd hh24:mi:ss\') as \"结束备份时间\",

       s.OPERATION as \"命令\",

       trunc(s.INPUT_BYTES/1024/1024,2) as \"INPUT-M\",

       trunc(s.OUTPUT_BYTES/1024/1024,2) as \"OUTPUT-M\",

       s.OBJECT_TYPE as \"对象类型\",

       s.MBYTES_PROCESSED as \"百分比\",

       s.OUTPUT_DEVICE_TYPE as \"设备类型\"

  from v$rman_status s,v$rman_backup_job_details b

  where to_char(s.START_TIME, \'yyyy-mm-dd hh24:mi:ss\') < to_char(sysdate,\'yyyy-mm-dd hh24:mi:ss\')

  and to_char(s.END_TIME, \'yyyy-mm-dd hh24:mi:ss\') > to_char(sysdate-7,\'yyyy-mm-dd hh24:mi:ss\')

  and s.COMMAND_ID=b.COMMAND_ID

  order by  s.START_TIME desc ;

select s.status as 备份状态,

       trunc((s.END_TIME-s.START_TIME)*24*60,0) \"备份用时(分钟)\",

       to_char(s.START_TIME, \'yyyy-mm-dd hh24:mi:ss\') as 开始备份时间,

       to_char(s.END_TIME, \'yyyy-mm-dd hh24:mi:ss\') as 结束备份时间,

       s.OPERATION as 命令,

       trunc(s.INPUT_BYTES/1024/1024,2) as \"INPUT/M\",

       trunc(s.OUTPUT_BYTES/1024/1024,2) as \"OUTPUT/M\",

       s.OBJECT_TYPE as \"对象类型\",

       s.MBYTES_PROCESSED as 百分比,

       s.OUTPUT_DEVICE_TYPE as \"设备类型\"

  from v$rman_status s

  where to_char(s.START_TIME, \'yyyy-mm-dd hh24:mi:ss\') < to_char(sysdate,\'yyyy-mm-dd hh24:mi:ss\')

  and to_char(s.END_TIME, \'yyyy-mm-dd hh24:mi:ss\') > to_char(sysdate-7,\'yyyy-mm-dd hh24:mi:ss\')

  order by  s.START_TIME desc ;

col  TIME_TAKEN_DISPLAY format a30

col  INPUT_BYTES_DISPLAY  format a20

col  OUTPUT_BYTES_DISPLAY   format a20

col  OUTPUT_DEVICE_TYP   format a20

col  INPUT_TYPE   format a20

set linesize 200

select  

start_time,end_time,

OUTPUT_DEVICE_TYPE,INPUT_TYPE,

INPUT_BYTES_DISPLAY,

OUTPUT_BYTES_DISPLAY,

INPUT_BYTES_PER_SEC/1024/1024 as in_mb_s,

OUTPUT_BYTES_PER_SEC/1024/1024 as out_mb_s,

TIME_TAKEN_DISPLAY,

ELAPSED_SECONDS

from v$rman_backup_job_details;

以上脚本也是参考一下：

再提供其他两个视图做一下参考

v$backup_sync_io
v$backup_async_io