Oracle 视图 ALL_APPLY_ERROR 官方解释,作用,如何使用详细说明
  iDU31ygkXmx7 2023年11月21日 42 0

本站中文解释

S

ALL_APPLY_ERRORS(所有应用错误)视图是Oracle数据库中的一个动态性视图,它提供了一种检查及应用解决策略的方法,用于发现并解决复制过程中出现的错误。

用途:

1.ALL_APPLY_ERRORS视图可以用来查询复制错误及其解决情况;

2.通过查询ALL_APPLY_ERRORS视图,可以获得以下信息:APPLY信息的行索引和行状态,相关错误信息,错误作用的表;

3.通过ALL_APPLY_ERRORS视图,可以根据获取的错误信息来诊断复制及解决策略的问题;

4.可以使用ALL_APPLY_ERRORS视图来查看特定的应用错误是否存在,这可以帮助开发者对特定应用表进行相应的处理。

使用方法:

1.查询应用错误:可以使用SELECT语句来查询ALL_APPLY_ERRORS视图详细信息;

2.解决应用错误:可以按照搜索到的错误信息提供的建议来解决该错误;

3.查看应用状态:可以使用ALL_APPLY_ERRORS视图的APPLY_STATUS字段来查看复制过程中应用的状态。

官方英文解释

ALL_APPLY_ERROR displays information about the error transactions generated by the apply processes that dequeue messages from queues accessible to the current user.

Related Views

  • DBA_APPLY_ERROR displays information about the error transactions generated by all apply processes in the database.

  • USER_APPLY_ERROR displays information about the error transactions generated by apply processes visible to the current user. This view does not display the SOURCE_ROOT_NAME column.

Column Datatype NULL Description

APPLY_NAME

VARCHAR2(128)

Name of the apply process at the local database which processed the transaction

QUEUE_NAME

VARCHAR2(128)

Name of the queue at the local database from which the transaction was dequeued

QUEUE_OWNER

VARCHAR2(128)

Owner of the queue at the local database from which the transaction was dequeued

LOCAL_TRANSACTION_ID

VARCHAR2(22)

Local transaction ID for the error transaction

SOURCE_DATABASE

VARCHAR2(128)

Database where the transaction originated

SOURCE_TRANSACTION_ID

VARCHAR2(128)

Original transaction ID at the source database

SOURCE_COMMIT_SCN

NUMBER

Original commit system change number (SCN) for the transaction at the source database

MESSAGE_NUMBER

NUMBER

Identifier for the message in the transaction that raised an error

ERROR_NUMBER

NUMBER

Error number of the error raised by the transaction

ERROR_MESSAGE

VARCHAR2(4000)

Error message of the error raised by the transaction

RECIPIENT_ID

NUMBER

User ID of the original user that applied the transaction

RECIPIENT_NAME

VARCHAR2(128)

Name of the original user that applied the transaction

MESSAGE_COUNT

NUMBER

Total number of messages inside the error transaction

ERROR_CREATION_TIME

DATE

Time that the error was created

SOURCE_COMMIT_POSITION

RAW(64)

Original commit position for the transaction

ERROR_TYPE

VARCHAR2(11)

NULL if the apply process can access all of the LCRs in the error transaction.

EAGER ERROR if the apply process cannot access all of the LCRs in the error transaction. This error type typically means that the apply process was applying LCRs in a large transaction. When the ERROR_TYPE is EAGER ERROR, manage the error transaction using the instructions in Oracle Database XStream
Guide
.

RECORD LCR indicates that a single LCR has been recorded as requested by user-specified error handling configuration

RECORD TXN NO LCRS indicates that the identified transaction encountered an error and only the transaction ID is recorded as requested by user-specified error handling configuration

RECORD TXN WITH LCRS indicates that the identified transaction encountered and error. The entire transaction is recorded as requested by user-specified error handling configuration.

UNHANDLED ERRORS NO LCR indicates that the identified transaction encountered an error and there was no error handling specified for this handler. No LCRs are recorded for this transaction.

DISCARDED is used to mark recorded and discarded LCRs.

SOURCE_ROOT_NAME

VARCHAR2(128)

The global name of the source root database

ERROR_POSITION

RAW(64)

LCR position at which the error occurred

See Also:

  • “DBA_APPLY_ERROR”

  • “USER_APPLY_ERROR”

  • Oracle Database XStream
    Guide
    for information on how to display detailed information about apply errors

【版权声明】本文内容来自摩杜云社区用户原创、第三方投稿、转载,内容版权归原作者所有。本网站的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@moduyun.com

  1. 分享:
最后一次编辑于 2023年11月21日 0

暂无评论

iDU31ygkXmx7