Oracle教程

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

本站中文解释

常计数据视图：

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


数据运维技术 » Oracle 视图 V$RMAN_STATUS 官方解释，作用，如何使用详细说明
分享到：

相关推荐