8.173 V$RMAN_BACKUP_SUBJOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS
merges similar operations within an RMAN session into a single row. For example, if there are four BACKUP DATAFILE <n>
commands, three RECOVERY COPY OF DATAFILE
commands, and one BACKUP RECOVERY AREA
command, this view will contain three rows - one each for BACKUP, ROLLFORWARD, and COPY_DISK_TO_TAPE operation.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier |
|
|
Together with |
|
|
Together with |
|
|
Can be BACKUP, ROLLFORWARD, VALIDATE, or COPY_DISK_TO_TAPE. A row for each suboperation type for the session will be in the output view. |
|
|
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). |
|
|
A value of |
|
|
YES or NO, depending upon whether or not a control file autobackup was done as part of this 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 autobackups performed by this job |
|
|
Compression ratio |
|
|
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. |
|
|
The ID of the container to which the data pertains. Possible values include:
|