V$RMAN_STATUS 视图

V$RMAN_STATUSdisplays 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.

V$RMAN_STATUS显示已完成和正在进行的RMAN任务。对于正在进行的任务，显示 progress 和 status，这些信息仅存在于内存中。当任务结束后，信息将存在控制文件中。

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`) 父recid，对应ROW_LEVEL列，子的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会话的记录id，也就是ROW_LEVEL=0的session
`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分了几类，其中session的level =0
`ROW_TYPE`	`VARCHAR2(19)`	Type of the row: `SESSION` `COMMAND` `RECURSIVE OPERATION` `session的话，敲了诸如rman target / 就可以看到一条记录（没有退出前这一条记录的status是failed，有些别扭），operation写的是RMAN` `command的话，对应的operation有BACKUP(进行备份)，LIST(LIST命令)，REPORT等等`
`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 比如备份有 ARCHIVELOG，CONTROLFILE ，DB INCR
`OUTPUT_DEVICE_TYPE`	`VARCHAR2(17)`	`DISK`,`SBT_TAPE`, or``. An``indicates that output was written to more than one device type.

[@more@]