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 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 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 entail 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.

When a job includes backups corresponding to multiple values, 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(4000) Same value as INPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G.
OUTPUT_BYTES_DISPLAY VARCHAR2(4000) 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(4000) 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(4000) 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(4000) Total time for the RMAN job, converted to a user-displayable format, such as hh:mm:ss.