Oracle教程

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

本站中文解释

Oracle视图是查看和监控数据库实例和数据库系统中的视图和状态信息的内置视图。V$DATAGUARD_CONFIG视图用于检索Data guard状态和配置信息，可以涵盖在Data guard环境中实现的单一数据库或多个数据库之间的复制。

使用V$DATAGUARD_CONFIG视图的语法如下：

SQL> SELECT属性,值
FROM V$DATAGUARD_CONFIG
WHERE / *指定的属性* /;

例如，可以查询Data Guard同步模式：

SQL> SELECT属性,值
FROM V$DATAGUARD_CONFIG
WHERE属性=’同步模式’;

可以使用此视图来确定Data Guard服务正在正常运行，所有客户端实例是否使用正确的模式等。

官方英文解释

V$DATAGUARD_CONFIG displays the unique database names defined with the DB_UNIQUE_NAME and LOG_ARCHIVE_CONFIG initialization parameters, providing a view of the Oracle Data Guard environment from any database in the configuration.

The first row of the view lists the unique database name of the current database that was specified with the DB_UNIQUE_NAME initialization parameter. Additional rows reflect the unique database names of the other databases in the configuration that were specified with the DG_CONFIG keyword of the LOG_ARCHIVE_CONFIG initialization parameter.

Column Datatype Description

DB_UNIQUE_NAME

VARCHAR2(30)

Unique database name

PARENT_DBUN

VARCHAR2(30)

DB_UNIQUE_NAME of the parent database, also known as the database that supplies live redo to the destination.

For example, suppose Boston is the DB_UNIQUE_NAME of the primary database, Chicago is the DB_UNIQUE_NAME of the Far Sync Instance, and Seattle is the DB_UNIQUE_NAME of the terminal standby database. Since Boston is the primary database, it has no parent database so the PARENT_DBUN for Boston will be NULL. Since Boston services Chicago, the PARENT_DBUN of Chicago will be Boston. Since Chicago services Seattle, Chicago will be the PARENT_DBUN for Seattle.

DEST_ROLE

VARCHAR2(17)

Type of archival destination database:

  • LOCAL – Local to primary database

  • PHYSICAL – Physical standby

  • FAR SYNC INSTANCE – Far Sync Instance

  • CROSS-INSTANCE – An instance of the primary

  • LOGICAL – Logical standby

  • SNAPSHOT – Snapshot standby database

  • DOWNSTREAM – Streams downstream capture database

CURRENT_SCN

NUMBER

The SCN up to which the specified database has applied redo

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

See Also:

  • “DB_UNIQUE_NAME”

  • “LOG_ARCHIVE_CONFIG”


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

相关推荐