介绍

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	备份所用的时间，值会转换为适合查看的格式