Oracle教程

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

本站中文解释

Oracle视图V$RMAN_OUTPUT是用来显示RMAN备份和恢复过程中的输出信息。它收集从RMAN SOL里备份和恢复会话中显示的信息，比如已备份块、备份日志、失败文件、成功恢复位置、调试信息等。

使用方法：
1、查看最近一次备份会话的输出信息，可使用如下SQL语句：
SELECT * FROM V$RMAN_OUTPUT WHERE SESSION_KEY IN(SELECT MAX(SESSION_KEY) FROM V$RMAN_OUTPUT);
2、通过指定时间范围来查找某一段时间内备份或恢复过程执行的输出信息，可使用如下SQL语句：
SELECT * FROM V$RMAN_OUTPUT WHERE START_TIME >= ‘&START_TIME’ AND END_TIME

官方英文解释

V$RMAN_OUTPUT displays messages reported by RMAN.

This is an in-memory view and is not recorded in the controlfile. The view can hold 32768 rows.

Column Datatype Description

SID

NUMBER

Session ID of the session which is running this RMAN operation

RECID

NUMBER

Record ID of the corresponding V$RMAN_STATUS row

STAMP

NUMBER

Timestamp of the corresponding V$RMAN_STATUS row

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)

OUTPUT

VARCHAR2(130)

Output text reported by RMAN

RMAN_STATUS_RECID

NUMBER

Owning V$RMAN_STATUS record ID

RMAN_STATUS_STAMP

NUMBER

Owning V$RMAN_STATUS record stamp

SESSION_KEY

NUMBER

Session identifier

GUID

NUMBER

The guid of the pluggable database (PDB) that did the RMAN operation. V$RMAN_OUTPUT captures the rman output.

If a PDB sysdba did the backup, the guid of the PDB is displayed in V$RMAN_OUTPUT. If root did the backup, then guid of the root is displayed in V$RMAN_OUTPUT. Root

A root user can see all of V$RMAN_OUTPUT rows (that is, the rows owned by all PDBs), but a PDB user can only see that PDB’s V$RMAN_OUTPUT rows (that is, no rows from root or other PDBs).

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_OUTPUT 官方解释，作用，如何使用详细说明
分享到：

相关推荐