侧边栏壁纸
博主头像
与晚风述往事博主等级

万般皆下品,唯有读书高。

  • 累计撰写 149 篇文章
  • 累计创建 29 个标签
  • 累计收到 7 条评论

目 录CONTENT

文章目录

V$RMAN_BACKUP_JOB_DETAILS动态性能视图

与晚风述往事
2021-12-12 / 0 评论 / 0 点赞 / 194 阅读 / 3,004 字 / 正在检测是否收录...
温馨提示:
本文最后更新于 2021-12-12,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。

介绍

V$RMAN_BACKUP_JOB_DETAILS视图能够让我们查询RMAN备份的一个概览信息,例如备份是否完成、备份耗时、备份输入和输出等信息。

视图详情

字段名 字段类型 描述 备注
SESSION_KEY NUMBER Session identifier 会话标识符
SESSION_RECID NUMBER Together, with SESSION_KEY and SESSION_STAMP, used to uniquely identify job output from V$RMAN_OUTPUT
SESSION_STAMP NUMBER Together, with SESSION_KEY and SESSION_RECID, used to uniquely identify job output from V$RMAN_OUTPUT
COMMAND_ID VARCHAR2(33) Either a user-specified SET COMMAND ID or a unique command ID generated by RMAN 用户指定的ID或者RMAN自动生成的唯一命令ID
START_TIME DATE Start time of the first BACKUP command in the job 作业中第一个备份开始的时间
END_TIME DATE End time of the last BACKUP command in the job 作业中最后一个备份结束的时间
INPUT_BYTES NUMBER Sum of all input file sizes backed up by this job 作业中备份的所有输入文件大小的总和
OUTPUT_BYTES NUMBER Output size of all pieces generated by this job 作业生成的所有备份集(输出文件)的总大小
STATUS_WEIGHT NUMBER Used internally by Enterprise Manager
OPTIMIZED_WEIGHT# NUMBER Used internally by Enterprise Manager
OBJECT_TYPE_WEIGHT NUMBER Used internally by Enterprise Manager
OUTPUT_DEVICE_TYPE VARCHAR2(17) Can be DISK, SBT, or *. An * indicates more than one device (in most cases, it will be DISK or SBT). 存储的类型,也可以理解为备份到哪里。DISK表示磁盘,SBT表示磁带,*代表两者都有
AUTOBACKUP_COUNT NUMBER Number of autobackups performed by this job 此作业执行的自动备份数
BACKED_BY_OSB VARCHAR2(3) A value of YES means the backup was done to Oracle Secure Backup. Otherwise, backed up by other third party tape library 是否为Oracle Secure Backup备份,YES表示是,NO表示其它第三方磁带库备份
AUTOBACKUP_DONE VARCHAR2(3) YES or NO, depending upon whether or not a control file autobackup was done as part of this backup job 是否自动备份了控制文件,YES表示是,NO表示否
STATUS VARCHAR2(23) One of the following values:
RUNNING WITH WARNINGS
RUNNING WITH ERRORS
COMPLETED
COMPLETED WITH WARNINGS
COMPLETED WITH ERRORS
FAILED
备份状态:
运行中,但有警告
运行中,但有错误
已完成备份
已完成备份但有警告
已完成备份但有错误
错误
INPUT_TYPE VARCHAR2(13) Contains one of the following values. If the user command does not satisfy one of them, then preference is given in order, from top to bottom of the list. DB FULL RECVR AREA DB INCR DATAFILE FULL DATAFILE INCR ARCHIVELOG CONTROLFILE SPFILE 备份类型, 数据库全备 闪回区,这个可能有歧义 数据库增量备份 数据文件全备 数据文件增量备份 归档日志备份 控制文件备份 spfile参数文件备份 如果用户不满足其中一个条件,则按照从列表最上面到最下面的顺序给出首选项
OPTIMIZED VARCHAR2(3) YES or NO, depending on whether optimization was applied. Applicable to backup jobs only. 是否启用备份优化,YES表示启用,NO表示不启用 仅适用于备份作业
ELAPSED_SECONDS NUMBER Number of elapsed seconds 已执行的秒数
COMPRESSION_RATIO NUMBER Compression ratio 压缩比
INPUT_BYTES_PER_SEC NUMBER Input read-rate-per-second 每秒输入读的速度
OUTPUT_BYTES_PER_SEC NUMBER Output write-rate-per-second 每秒输出写的速度
INPUT_BYTES_DISPLAY VARCHAR2(4000) Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
OUTPUT_BYTES_DISPLAY VARCHAR2(4000) Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on
INPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000) Input read-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on. 每秒输入读取速度,这里的值更适合查看,因为它会将单位换算为MB、GB、TB、PB
OUTPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000) Output write-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on. 每秒输出写入速度,这里的值更适合查看,因为它会将单位换算为MB、GB、TB、PB
TIME_TAKEN_DISPLAY VARCHAR2(4000) Time taken, shown in user-displayable format <nn>h:<nn>m:<nn>s 备份所用的时间,值会转换为适合查看的格式
0

评论区