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

本站中文解释

Oracle视图V$GOLDENGATE_MESSAGE_TRACKING用于跟踪GoldenGate复制时,所处理的消息。这些消息可以是在源数据库中完成的DML操作,也可以是在目标数据库中完成的DML操作。它用于跟踪复制过程中已经完成的操作,以及正等待复制的操作。

OracleV$GOLDENGATE_MESSAGE_TRACKING视图也有助于检查复制是否有效,以及在哪些步骤出现问题。它还能够提供有关正在等待复制的信息,以及在消息复制期间出现的错误的详细信息。

使用V$GOLDENGATE_MESSAGE_TRACKING视图的方法是:

1.查询复制过程中,仍未处理的消息条目:

SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE STATUS=’PENDING’;

2.查询复制过程中出现错误的消息条目:

SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE STATUS=’ERROR’;

3.检查消息条目是否已处理:

SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE STATUS=’COMPLETED’;

4.检查复制消息的详细内容:

SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE MESSAGE_COLUMN='[MESSAGE_DETAIL]’;

官方英文解释

V$GOLDENGATE_MESSAGE_TRACKING displays information about LCRs tracked through the stream that are processed by Oracle GoldenGate components.

You can track an LCR through a stream using one of the following methods:

  • Set the message_tracking_frequency apply process parameter to 1 or another relatively low value via the Oracle GoldenGate DBOPTIONS INTEGRATEDPARAMS parameter.

  • Use the DBMS_XSTREAM_ADM.SET_MESSAGE_TRACKING procedure to specify a tracking label that becomes part of each LCR generated by the current session.

    When the actions parameter in the DBMS_XSTREAM_ADM.SET_MESSAGE_TRACKING procedure is set to DBMS_XSTREAM_ADM.ACTION_MEMORY, information about the LCRs is tracked in memory, and this view is populated with information about the LCRs. Currently, DBMS_XSTREAM_ADM.ACTION_MEMORY is the only valid setting for the actions parameter in the procedure.

Column Datatype Description

TRACKING_LABEL

VARCHAR2(128)

User-specified tracking label

TAG

RAW(128)

First 128 bytes of the tag of the LCR

COMPONENT_NAME

VARCHAR2(128)

Name of the component that processed the LCR

COMPONENT_TYPE

VARCHAR2(128)

Type of the component that processed the LCR

ACTION

VARCHAR2(50)

Action performed on the LCR

ACTION_DETAILS

VARCHAR2(312)

Details of the action

TIMESTAMP

TIMESTAMP(9) WITH TIME ZONE

Time when the action was performed

MESSAGE_CREATION_TIME

DATE

Time when the message was created

MESSAGE_NUMBER

NUMBER

SCN of the message

TRACKING_ID

RAW(16)

Globally unique OID of the LCR

SOURCE_DATABASE_NAME

VARCHAR2(128)

Name of the source database

OBJECT_OWNER

VARCHAR2(128)

Owner of the object

OBJECT_NAME

VARCHAR2(128)

Name of the object

XID

VARCHAR2(128)

Transaction ID

COMMAND_TYPE

VARCHAR2(128)

Command type of the LCR

MESSAGE_POSITION

RAW(64)

Position of the message

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:

Oracle Database PL/SQL
Packages and Types Reference
for more information about the DBMS_XSTREAM_ADM.SET_MESSAGE_TRACKING procedure


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