RC_RMAN_BACKUP_JOB

5.49 RC_RMAN_BACKUP_JOB_DETAILS

RC_RMAN_BACKUP_JOB_DETAILS provides detailed information on RMAN backup jobs.

An RMAN job is the set of commands executed within an RMAN session. An RMAN backup job is the set of BACKUP commands executed in one RMAN job. For example, a BACKUP DATABASE and BACKUP ARCHIVELOG ALL command executed in the same RMAN job compose a single RMAN backup job.

This view contains one row for each RMAN session, even if multiple BACKUP commands are executed in the same session. The SESSION_KEY column is the unique key for the RMAN session in which the backup job occurred. Details for operations performed during an RMAN session are available in the RC_RMAN_BACKUP_SUBJOB_DETAILS view.

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

Column	Data Type	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`	Identifier for the RMAN session. Use in joins with `RC_RMAN_OUTPUT` and `RC_RMAN_BACKUP_JOB_DETAILS`.
`SESSION_RECID`	`NUMBER`	With `SESSION_KEY` and `SESSION_STAMP`, used to uniquely identify job's output from `RC_RMAN_OUTPUT`
`SESSION_STAMP`	`NUMBER`	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 RMAN job.
`END_TIME`	`DATE`	End time of the last backup command in the RMAN job.
`INPUT_BYTES`	`NUMBER`	Sum of sizes of all input files backed up during this RMAN job.
`OUTPUT_BYTES`	`NUMBER`	Sum of sizes of all output backup pieces generated by this RMAN 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 `*`. An asterisk indicates a backup job that wrote its output to multiple device types.
`AUTOBACKUP_COUNT`	`NUMBER`	Number of autobackups performed by this RMAN job.
`BACKED_BY_OSB`	`VARCHAR2(3)`	Indicates whether the backup piece is backed up to Oracle Secure Backup (`YES`) or not (`NO`).
`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,RUNNING WITH WARNINGS`, `RUNNING WITH ERRORS`, `COMPLETED`, `COMPLETED WITH WARNINGS`, `COMPLETED WITH ERRORS`, `FAILED`. A failed job does not mean that no backup sets were created. It is possible that the job failed after RMAN created some backup sets. Thus, the `RC_BACKUP_SET_DETAILS` view may contain rows describing backup sets created successfully by the backup job. You can join this view with `RC_BACKUP_SET_DETAILS` to obtain more information about the failed backup job.
`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. If a job includes backups corresponding to multiple values, then multiple rows 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(32K)`	Same value as `INPUT_BYTES`, but converted to a user-displayable format, for example, 798.01M or 5.25G.
`OUTPUT_BYTES_DISPLAY`	`VARCHAR2(32K)`	Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example, 798.01M or 5.25G.
`INPUT_BYTES_PER_SEC_DISPLAY`	`VARCHAR2(32K)`	Same value as `INPUT_BYTES_PER_SEC`, but converted to a user-displayable format, for example, 798.01M or 5.25G.
`OUTPUT_BYTES_PER_SEC_DISPLAY`	`VARCHAR2(32K)`	Same value as `OUTPUT_BYTES_PER_SEC`, but converted to a user-displayable format, for example, 798.01M or 5.25G.
`TIME_TAKEN_DISPLAY`	`VARCHAR2(32K)`	Total time for the RMAN job, converted to a user-displayable format, such as hh:mm:ss.