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
`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: `SESSION` `COMMAND` `RECURSIVE OPERATION`
`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: `RUNNING` `RUNNING WITH WARNINGS` `RUNNING WITH ERRORS` `COMPLETED` `COMPLETED WITH WARNINGS` `COMPLETED WITH ERRORS` `FAILED`
`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.
`OSB_ALLOCATED`	`VARCHAR2(3)`	A value of `YES` means an Oracle Secure Backup channel was allocated during the specified operation identified by the `V$RMAN_STATUS` view.