V$RMAN_BACKUP_JOB_DETAILS
displays details about backup jobs.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier |
|
|
Together, with |
|
|
Together, with |
|
|
Either a user-specified SET COMMAND ID or a unique command ID generated by RMAN |
|
|
Start time of the first BACKUP command in the job |
|
|
End time of the last BACKUP command in the job |
|
|
Sum of all input file sizes backed up by this job |
|
|
Output size of all pieces generated by this job |
|
|
Used internally by Enterprise Manager |
|
|
Used internally by Enterprise Manager |
|
|
Used internally by Enterprise Manager |
|
|
Can be DISK, SBT, or *. An * indicates more than one device (in most cases, it will be DISK or SBT). |
|
|
Number of autobackups performed by this job |
|
|
A value of |
|
|
YES or NO, depending upon whether or not a control file autobackup was done as part of this backup job |
|
|
One of the following values:
|
|
|
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.
|
|
|
YES or NO, depending on whether optimization was applied. Applicable to backup jobs only. |
|
|
Number of elapsed seconds |
|
|
Compression ratio |
|
|
Input read-rate-per-second |
|
|
Output write-rate-per-second |
|
|
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on. |
|
|
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on |
|
|
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 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, shown in user-displayable format <nn>h:<nn>m:<nn>s |
|
|
The ID of the container to which the data pertains. Possible values include:
|