Oracle教程

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

本站中文解释

Oracle视图V$DATAGUARD_STATUS用来查看Oracle数据库实例的数据守护状态信息，也就是说，数据守护的状态能够从这个视图中得出。

用途:

V$DATAGUARD_STATUS可以让用户，特别是DBA，更加容易地查看数据库实例的当前数据守护状态，以保持系统稳定和恢复性能。

使用方法:

要查看V$DATAGUARD_STATUS视图上的数据，可以使用以下语句:
SELECT * FROM V$DATAGUARD_STATUS;
这将打印出实例上当前数据守护状态的报告，例如主实例或从实例，级别，状态，开始时间和最后同步的时间点等。

官方英文解释

V$DATAGUARD_STATUS displays messages recently written to the alert log or server process trace files that concern physical standby databases or redo transport services for all standby database types.

Column Datatype Description

FACILITY

VARCHAR2(24)

Facility that encountered the event:

  • Crash Recovery

  • Log Transport Services

  • Log Apply Services

  • Role Management Services

  • Remote File Server

  • Fetch Archive Log

  • Data Guard

  • Network Services

SEVERITY

VARCHAR2(13)

Severity of the event:

  • Informational – Informational message

  • Warning – Warning message

  • Error – Indicates the process has failed

  • Fatal

  • Control – An expected change in state such as the start or completion of an archival, log recovery, or switchover operation

DEST_ID

NUMBER

Destination ID number to which the event pertains. If the event does not pertain to a particular destination, then the value is 0.

MESSAGE_NUM

NUMBER

A chronologically increasing number giving each event a unique number

ERROR_CODE

NUMBER

Error ID pertaining to the event

CALLOUT

VARCHAR2(3)

Reserved for future use

TIMESTAMP

DATE

Message date

MESSAGE

VARCHAR2(256)

A text message describing the event

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

相关推荐