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 |
OPERATION |
VARCHAR2(33) |
The possible values are BACKUP , ROLLFORWARD, VALIDATE, or BACKUPSET. For each operation type in a session, the view contains one row with each value representing all operations of that type during the session. |
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 job 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. |
OBJECT_TYPE_WEIGHT |
NUMBER |
Used internally by Enterprise Manager. |
OPTIMIZED_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_DONE |
VARCHAR2(3) |
'YES' or 'NO', depending upon whether a control file autobackup was done as part of this 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: DATABASE FULL, RECOVERY AREA, DATABASE INCR, DATAFILE FULL, DATAFILE INCR, ARCHIVELOG, CONTROLFILE, SPFILE.
When a subjob 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) |
If OPERATION=BACKUP, then OPTIMIZED is 'YES' or 'NO', depending on whether backup optimization was applied. |
AUTOBACKUP_COUNT |
NUMBER |
Number of autobackups performed by this job. |
COMPRESSION_RATIO |
NUMBER |
Compression ratio for this backup. |
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. |