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.
Session ID of the session which is running this RMAN operation
Record ID of the row in the controlfile
Timestamp of the row (RECID + STAMP is unique)
Record ID of the parent row of this row (corresponding V$RMAN_STATUS row with ROW_LEVEL = ROW_LEVEL - 1)
Timestamp of the parent row of this row (corresponding V$RMAN_STATUS row with ROW_LEVEL = ROW_LEVEL - 1)
Record ID of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0)
Timestamp of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0)
Level of the row. The session has level 0.
Type of the row:
Command ID set by the RMAN SET COMMAND ID command. If not set, then RMAN will create a unique number.
Name of the command in the execution explained by this row
Status of the operation:
RUNNING WITH WARNINGS
RUNNING WITH ERRORS
COMPLETED WITH WARNINGS
COMPLETED WITH ERRORS
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
DISK, SBT_TAPE, or *. An * indicates that output was written to more than one device type.