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