Oracle教程

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

本站中文解释

Oracle视图DBA_LOGSTDBY_PARAMETERS用于查看数据库中的实时恢复的参数配置情况，其主要在Logical Standby数据库中有用。其用于查看以下参数值：

LOG_ARCHIVE_DEST_n : Logical Standby间架构特定的归档模式–Logical Standby归档归档路径

CONFIGURE_STANDBY_FileMANAGEMENT: 配置归档模式，用于控制Logical Standby数据库上的归档文件管理

LOG_ARCHIVE_DEST_STATE_n: 按Logical Standby路径和归档模式定义Logical Standby归档路径

LOG_ARCHIVE_MIN_SUCCEED_DEST: 这是XXX归档文件要成功传输到Logical Standby站点的归档路径。

使用方式：

可以通过执行以下查询来使用此视图：

SELECT * FROM DBA_LOGSTDBY_PARAMETERS;

官方英文解释

DBA_LOGSTDBY_PARAMETERS displays the list of parameters used by SQL apply for logical standby databases.

This view is for logical standby databases only.

Column Datatype NULL Description

NAME

VARCHAR2(64)

Name of the parameter:

  • MAX_SGA – System global area (SGA) allocated for the log apply services cache (in megabytes)

  • MAX_SERVERS – Number of processes used by SQL Apply services

  • PREPARE_SERVERS – Controls the number of parallel execution servers used to prepare changes

  • APPLY_SERVERS – Controls the number of parallel execution servers used to apply changes

  • MAX_EVENTS_RECORDED – Number of events stored in the DBA_LOGSTDBY_EVENTS view

  • RECORD_SKIP_ERRORS – Indicates records that are skipped

  • RECORD_SKIP_DDL – Indicates skipped DDL statements

  • RECORD_APPLIED_DDL – Indicates applied DDL statements

  • RECORD_UNSUPPORTED_OPERATIONS – Shows whether SQL Apply will capture information about transactions that did unsupported operations at the primary database in the DBA_LOGSTDBY_EVENTS view

  • EVENT_LOG_DEST – Indicates where SQL Apply records the occurrence of an interesting event

  • LOG_AUTO_DELETE – Shows whether SQL Apply will automatically delete remote archived logs received from the primary database, once the contents of the logs are applied at the logical standby database.

  • LOG_AUTO_DEL_RETENTION_TARGET – How many minutes a remote archived log received from the primary database will be retained at the logical standby database, once the contents of the log are applied by SQL Apply.

  • PRESERVE_COMMIT_ORDER – Shows whether transactions are committed at the logical standby database in the same order that they were committed at the primary database

VALUE

VARCHAR2(2000)

Value of the parameter

UNIT

VARCHAR2(64)

Unit of the value, if applicable

SETTING

VARCHAR2(64)

Possible values are as follows:

  • SYSTEM – Parameter value was not explicitly set by the user. However, the user can change it with an appropriate call to the APPLY_SET procedure.

  • USER – Parameter value was explicitly set by the user

DYNAMIC

VARCHAR2(64)

YES if the parameter can be set dynamically (that is, without having to stop SQL Apply)

NO if setting the parameter requires that SQL Apply be stopped

Note:

In a CDB, this view shows data when queried in the root.


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

相关推荐