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 |
---|---|---|
SID |
NUMBER |
Session ID of the session which is running this RMAN operation |
RECID |
NUMBER |
Record ID of the row in the controlfile |
STAMP |
NUMBER |
Timestamp of the row (RECID + STAMP is unique) |
PARENT_RECID |
NUMBER |
Record ID of the parent row of this row (corresponding V$RMAN_STATUS row with ROW_LEVEL = ROW_LEVEL - 1 ) |
PARENT_STAMP |
NUMBER |
Timestamp of the parent row of this row (corresponding V$RMAN_STATUS row with ROW_LEVEL = ROW_LEVEL - 1 ) |
SESSION_RECID |
NUMBER |
Record ID of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0 ) |
SESSION_STAMP |
NUMBER |
Timestamp of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0 ) |
ROW_LEVEL |
NUMBER |
Level of the row. The session has level 0 . |
ROW_TYPE |
VARCHAR2(19) |
Type of the row:
|
COMMAND_ID |
VARCHAR2(33) |
Command ID set by the RMAN SET COMMAND ID command. If not set, then RMAN will create a unique number. |
OPERATION |
VARCHAR2(33) |
Name of the command in the execution explained by this row |
STATUS |
VARCHAR2(23) |
Status of the operation:
|
MBYTES_PROCESSED |
NUMBER |
Percentage of the job completed; null if not applicable for the operation |
START_TIME |
DATE |
Start time of the job |
END_TIME |
DATE |
End time of the job |
INPUT_BYTES |
NUMBER |
Number of input bytes read |
OUTPUT_BYTES |
NUMBER |
Number of output bytes written |
OPTIMIZED |
VARCHAR2(3) |
YES, if backup optimization was applied during the backup job. Otherwise, NO. |
OBJECT_TYPE |
VARCHAR2(13) |
Identifies types of objects backed up |
OUTPUT_DEVICE_TYPE |
VARCHAR2(17) |
DISK , SBT_TAPE , or * . An * indicates that output was written to more than one device type. |