8.179 V$RMAN_STATUS
V$RMAN_STATUS
displays the finished and on-going RMAN jobs. For on-going jobs, this view displays progress and status. The jobs which are in progress are stored only in memory while the finished jobs are stored in the controlfile.
Column | Datatype | Description |
---|---|---|
|
|
Session ID of the session which is running this RMAN operation |
|
|
Record ID of the row in the controlfile |
|
|
Timestamp of the row ( |
|
|
Record ID of the parent row of this row (corresponding |
|
|
Timestamp of the parent row of this row (corresponding |
|
|
Record ID of the session (corresponding V$RMAN_STATUS row with |
|
|
Timestamp of the session (corresponding V$RMAN_STATUS row with |
|
|
Level of the row. The session has level |
|
|
Type of the row:
|
|
|
Command ID set by the RMAN |
|
|
Name of the command in the execution explained by this row |
|
|
Status of the operation:
|
|
|
Percentage of the job completed; null if not applicable for the operation |
|
|
Start time of the job |
|
|
End time of the job |
|
|
Number of input bytes read |
|
|
Number of output bytes written |
|
|
YES, if backup optimization was applied during the backup job. Otherwise, NO. |
|
|
Identifies types of objects backed up |
|
|
|
|
|
A value of |
|
|
The ID of the container to which the data pertains. Possible values include:
|