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

本站中文解释

Oracle的视图是一种快速查询数据的方法,DBA_LOGSTDBY_EVENTS视图是维护特定事件的位置,每个事件有一个全局位置和属性,可以查看特定日志位置的特定事件的信息,通常用于创建和维护日志传递任务。

使用DBA_LOGSTDBY_EVENTS视图,可以查看在激活日志传递任务时可用的事件。可以使用下面的SQL语句来列出特定位置及其特定事件的信息:

select *
from dba_logstdby_events
where logstdby_applied_sequence = ‘&input’
and logstdby_applied_branch = ‘&branch’;

官方英文解释

DBA_LOGSTDBY_EVENTS displays information about the activity of the logical standby database system.

It can be used to determine the cause of failures that occur when applying redo data to logical standby databases. This view is for logical standby databases only.

Column Datatype NULL Description

EVENT_TIME

DATE

Time when the event was logged

EVENT_TIMESTAMP

TIMESTAMP(6)

NOT NULL

Timestamp when the event was logged

START_SCN

NUMBER

The SCN at which the associated transaction started at the primary database. This SCN refers to the system change number at the primary database.

CURRENT_SCN

NUMBER

SCN associated with the change at the primary database. If a failure occurred, then examine this column to determine which archived log file contains the source of the failure (for example, an unsupported record).

COMMIT_SCN

NUMBER

SCN value on which the change was committed at the primary database

XIDUSN

NUMBER

Transaction ID undo segment number at the primary database of the associated transaction

XIDSLT

NUMBER

Transaction ID slot number at the primary database of the associated transaction

XIDSQN

NUMBER

Transaction ID sequence number at the primary database of the associated transaction

EVENT

CLOB

Statement that was being processed when the failure occurred

STATUS_CODE

NUMBER

Status (or Oracle error code) belonging to the STATUS message

STATUS

VARCHAR2(2000)

Description of the current activity of the process or the reason why the apply operation stopped

SRC_CON_NAME

VARCHAR2(30)

Identifies the PDB name at the primary database where the transaction was executed

SRC_CON_ID

NUMBER

Contains the PDB ID (the PDB_ID column from the DBA_PDBS view) of the primary database where the associated change was generated.

Note:

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


数据运维技术 » Oracle 视图 DBA_LOGSTDBY_EVENTS 官方解释,作用,如何使用详细说明