RC_RMAN_BACKUP_JOB_DETAILS

RC_RMAN_BACKUP_JOB_DETAILS provides detailed information on individual RMAN backup sessions, combining all operations within the session. Details for individual types of operation performed during the session are available in the RC_RMAN_BACKUP_SUBJOB_DETAILS view.

This view is primarily intended to be used internally by Enterprise Manager.

Column	Datatype	Description
`DB_KEY`	`NUMBER`	The primary key for this database.
`DB_NAME`	`VARCHAR2(8)`	The `DB_NAME` of the database incarnation to which this record belongs.
`SESSION_KEY`	`NUMBER`	Session identifier. Use in joins with `RC_RMAN_OUTPUT`.
`SESSION_RECID`	`NUMBER`	Together with `SESSION_KEY` and SESSION_STAMP, used to uniquely identify job's output from `RC_RMAN_OUTPUT`
`SESSION_STAMP`	`NUMBER`	Together with SESSION_RECID and SESSION_KEY, used to uniquely identify job's output from RC_RMAN_OUTPUT
`COMMAND_ID`	`VARCHAR2(33)`	Either a user-specified value set using SET COMMAND ID, or an RMAN-generated unique command 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 sizes of all input files backed up during this job.
`OUTPUT_BYTES`	`NUMBER`	Sum of sizes of all output pieces generated by this job.
`STATUS_WEIGHT`	`NUMBER`	Used internally by Enterprise Manager.
`OPTIMIZED_WEIGHT`	`NUMBER`	Used internally by Enterprise Manager.
`INPUT_TYPE_WEIGHT`	`NUMBER`	Used internally by Enterprise Manager.
`OUTPUT_DEVICE_TYPE`	`VARCHAR2(17)`	'DISK', 'SBT_TAPE' or ''. A '' indicates a backup job that wrote its output to more than one device type.
`AUTOBACKUP_COUNT`	`NUMBER`	Number of autobackups performed by this job.
`AUTOBACKUP_DONE`	`VARCHAR2(3)`	'YES' or 'NO', depending upon whether 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 a value indicating the type of input for this backup. For possible values, see the RC_RMAN_BACKUP_TYPE view. When a job includes backups corresponding to more than one of these values, multiple rows will appear in the view, corresponding to the different INPUT_TYPE values for each type of input, with corresponding values for the INPUT_BYTES, OUTPUT_BYTES, INPUT_BYTES_DISPLAY, OUTPUT_BYTES_DISPLAY fields.
`OPTIMIZED`	`VARCHAR2(3)`	'YES' or 'NO', depending on whether backup optimization was applied.
`ELAPSED_SECONDS`	`NUMBER`	Number of seconds elapsed during execution of this backup job.
`COMPRESSION_RATIO`	`NUMBER`	Compression ratio for this backup.
`INPUT_BYTES_PER_SEC`	`NUMBER`	Input read rate, in bytes/second.
`OUTPUT_BYTES_PER_SEC`	`NUMBER`	Output write rate, in bytes/second.
`INPUT_BYTES_DISPLAY`	`VARCHAR2(4000)`	Same value as `INPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`OUTPUT_BYTES_DISPLAY`	`VARCHAR2(4000)`	Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`INPUT_BYTES_PER_SEC_DISPLAY`	`VARCHAR2(4000)`	Same value as `INPUT_BYTES_PER_SEC`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`OUTPUT_BYTES_PER_SEC_DISPLAY`	`VARCHAR2(4000)`	Same value as `OUTPUT_BYTES_PER_SEC`, but converted to a user-displayable format, for example nM, nG, nT, nP.
`TIME_TAKEN_DISPLAY`	`VARCHAR2(4000)`	Total time for job, converted to a user-displayable format, such as hhh:mmm:sss.