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

本站中文解释

Oracle视图V$ARCHIVE_DEST_STATUS存储归档位置状态信息,这些信息是未从当前节点读取,而是从归档日志文件中收集而来的,可显示指定归档注册组或归档位置的归档日志的当前位置、传输状态等信息。其结构如下:

OBJECT | DESCRIPTION
——– | ————-
DEST_ID | 归档位置ID
DESTINATION | 归档位置名称
STATUS | 归档位置的状态
THREAD# | 针对该归档位置的归档线程编号
SEQUENCE# | 归档位置当前应归档的日志序列号
BLOCK# | 归档位置当前应归档的块序列号
BYTES | 归档日志文件当前应归档的字节数
APPLIED | 不可用
DELAYED | 实际推迟的状态

使用该视图主要用于以下功能:

1. 确定归档是否暂停(STATUS为STOPPED时表示暂停)。

2. 确定当前应归档的日志SEQUENCE#和BLOCK#,及每块应归档的大小BYTES。

3. 监控事务推迟(DELAYED > 0时,表示存在受影响的事务)。

使用方式如下:

SELECT * FROM v$ARCHIVE_DEST_STATUS;

官方英文解释

V$ARCHIVE_DEST_STATUS displays run time and configuration information for the archived redo log destinations.

The information in this view does not persist across an instance shutdown.

Column Datatype Description

DEST_ID

NUMBER

Identifies the log archive destination parameter (1 to 31)

DEST_NAME

VARCHAR2(256)

Log archive destination parameter name

STATUS

VARCHAR2(9)

Current status of the destination:

  • VALID – Initialized and available

  • INACTIVE – No destination information

  • DEFERRED – Manually disabled by the user

  • ERROR – Error during open or copy

  • DISABLED – Disabled after error

  • BAD PARAM – Parameter has errors

  • ALTERNATE – Destination is in an alternate state

  • FULL – Exceeded quota size for the destination

TYPE

VARCHAR2(14)

Type of archival destination database:

  • LOCAL – Local to primary database

  • PHYSICAL – Physical standby

  • CROSS-INSTANCE – An instance of the primary

  • LOGICAL – Logical standby

  • SNAPSHOT – Snapshot standby database

  • DOWNSTREAM – Streams downstream capture database

  • FAR SYNC – Far Sync Instance

DATABASE_MODE

VARCHAR2(15)

Current mode of the archival destination database:

  • STARTED – Instance started, not mounted

  • MOUNTED – Mounted

  • MOUNTED-STANDBY – Mounted standby

  • OPEN – Open read/write

  • OPEN_READ-ONLY – Open read-only

RECOVERY_MODE

VARCHAR2(23)

Current apply mode at the archival destination:

  • IDLE – Managed recovery is not active

  • MANAGED – Managed recovery is active. This value is used when the standby database is mounted. In this recovery mode, users cannot query data on the standby.

  • MANAGED WITH QUERY – Managed recovery is active in this recovery mode. In a non-CDB, this value is used when the database is open, and users can query data on the standby. In a CDB, this value is used when one or more PDBs in the CDB are open, and users can query data on the standby.

  • MANAGED REAL TIME APPLY – In this recovery mode, log apply services recover redo data from standby redo logs at the same time the logs are being written to, as opposed to recovering redo from archived redo logs when a log switch occurs. In this recovery mode, users cannot query data on the standby.

  • MANAGED REAL TIME APPLY WITH QUERY – In this recovery mode, log apply services recover redo data from standby redo logs at the same time the logs are being written to, as opposed to recovering redo from archived redo logs when a log switch occurs. In a non-CDB, this mode is used when the database is open, and users can query data on the standby. In a CDB, this value is used when one or more PDBs in the CDB are open, and users can query data on the standby.

  • LOGICAL REAL TIME APPLY – Real time SQL Apply

  • LOGICAL APPLY – SQL Apply

PROTECTION_MODE

VARCHAR2(20)

Indicates whether the database is protected:

  • MAXIMUM PROTECTION

  • MAXIMUM AVAILABILITY

  • RESYNCHRONIZATION

  • MAXIMUM PERFORMANCE

  • UNPROTECTED

DESTINATION

VARCHAR2(256)

Specifies the location where the redo data is to be archived

STANDBY_LOGFILE_COUNT

NUMBER

Indicates the total number of standby redo logs created on the standby database

STANDBY_LOGFILE_ACTIVE

NUMBER

Indicates the total number of standby redo logs on the standby database that are active and contain primary database online redo log information

ARCHIVED_THREAD#

NUMBER

Identifies the thread number of the most recent archived redo log received at the destination

ARCHIVED_SEQ#

NUMBER

Identifies the log sequence number of the most recent archived redo log received at the destination

APPLIED_THREAD#

NUMBER

Identifies the thread number of the most recent applied redo log received at the destination

APPLIED_SEQ#

NUMBER

Identifies the log sequence number of the most recent applied redo log received at the destination

ERROR

VARCHAR2(256)

Displays the error text

SRL

VARCHAR2(3)

Indicates whether standby redo logfiles are used on the standby database (YES) or not (NO)

DB_UNIQUE_NAME

VARCHAR2(30)

Specifies the unique database name of the current instance that was defined with the DB_UNIQUE_NAME attribute on the LOG_ARCHIVE_DEST_n parameter

SYNCHRONIZATION_STATUS

VARCHAR2(22)

Possible values for this column are as follows:

  • CHECK CONFIGURATION – Synchronization with this destination is not possible because this database is either not in MAXIMUM PROTECTION or MAXIMUM AVAILABILITY data protection mode, or the LOG_ARCHIVE_DEST_n parameter associated with this destination has not been configured with the SYNC and AFFIRM attributes.

  • CHECK STANDBY REDO LOG – The standby redo log at this destination is configured improperly.

  • CHECK NETWORK – One or more instances of this database cannot send redo data to this destination.

  • DESTINATION HAS A GAP – This destination is missing redo data needed for synchronization with this database.

  • OK – This destination is synchronized with this database.

  • NOT AVAILABLE – Synchronization status is not available.

See Also: Oracle Data Guard Concepts
and Administration
for more information about redo transport configuration

SYNCHRONIZED

VARCHAR2(3)

Possible values are:

  • YES – This destination is synchronized with the primary database.

  • NO – The destination is not synchronized with the primary database.

  • UNKNOWN – The synchronization status of this destination cannot be determined.

GAP_STATUS

VARCHAR2(24)

Redo gap status:

  • NO GAP – Destination does not have a redo gap.

  • LOG SWITCH GAP – Destination has not yet received all of the redo from the previous log file.

  • RESOLVABLE GAP – Destination has a redo gap that can be automatically resolved by fetching the missing redo from this database.

  • UNRESOLVABLE GAP – Destination has a redo gap that cannot be automatically resolved by fetching the missing redo from this database and there are no other destinations from which redo can be fetched.

  • LOCALLY UNRESOLVABLE GAP – Destination has a redo gap that cannot be automatically resolved by fetching the missing redo from this database. It may be possible to resolve the gap by fetching the missing redo from another destination.

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$ARCHIVE_DEST_STATUS 官方解释,作用,如何使用详细说明