Oracle 视图 V$RMAN_BACKUP_JOB_DETAILS 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 V$RMAN_BACKUP_JOB_DETAILS 官方解释，作用，如何使用详细说明 10-18

本站中文解释

视图

Oracle视图V$RMAN_BACKUP_JOB_DETAILS用于描述RMAN会话中每个备份作业的详细信息。它存储了关于来自RMAN备份的每个作业的诊断信息的记录。我们可以通过V$RMAN_BACKUP_JOB_DETAILS视图来监视进行中的备份作业，并且可以查看已完成的备份作业执行的状态、消耗的时间等等，以便了解RMAN备份是否有效。我们可以使用这个视图来确定给定备份作业的指定阶段是否已成功完成。

语法：
SELECT *
FROM v$rman_backup_job_details
WHERE ;

其中可以是任何SQL条件，例如“job_name=My_Backup_Job”。

官方英文解释

V$RMAN_BACKUP_JOB_DETAILS displays details about backup jobs.

Column	Datatype	Description
`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
`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).
`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.
`AUTOBACKUP_DONE`	`VARCHAR2(3)`	YES or NO, depending upon whether or not a control file autobackup was done as part of this backup job
`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
`OPTIMIZED`	`VARCHAR2(3)`	YES or NO, depending on whether optimization was applied. Applicable to backup jobs only.
`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.
`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.
`TIME_TAKEN_DISPLAY`	`VARCHAR2(4000)`	Time taken, shown in user-displayable format <nn>h:<nn>m:<nn>s
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

编辑：568数据