Oracle 视图 V$RMAN_STATUS 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 V$RMAN_STATUS 官方解释，作用，如何使用详细说明 10-15

本站中文解释

常计数据视图：

V$RMAN_STATUS 是用来显示当前RMAN 各种状态操作的视图，比如备份、恢复、重新建立控制文件等。它由控制文件的回收段（recycledsegment）存储例程创建，包括操作类型、相关块号、可读性状态等信息，也包括打开和结束的时间戳。V$RMAN_STATUS 视图可以执行以下SQL 语句来查看正在执行的RMAN 操作：

SELECT SESSION_KEY,OPERATION,START_TIME,(ELAPSED_SECONDS/60)||’ minutes’ ELAPSED_TIME
FROM V$RMAN_STATUS ;

其他使用V$RMAN_STATUS 的查询示例：

–查询指定的备份操作的总耗时。
SELECT OPERATION,SUM(ELAPSED_SECONDS/60) TOTAL_TIME
FROM V$RMAN_STATUS WHERE OPERATION LIKE ‘Backup%’
GROUP BY OPERATION ;

–查询指定恢复操作的每个块号的耗时。
SELECT OPERATION,BLOCK_ID,SUM(ELAPSED_SECONDS/60)||’ minutes’ ELAPSED_TIME
FROM V$RMAN_STATUS WHERE OPERATION LIKE ‘Restore %block%’
GROUP BY OPERATION,BLOCK_ID ;

官方英文解释

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.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

编辑：一起学习网