V$RMAN_BACKUP_JOB_DETAILS

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