Oracle教程

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

本站中文解释

Oracle视图DBA_GOLDENGATE_SUPPORT_MODE显示了使用Oracle GoldenGate 支持的流复制模式。它包含以下列：

* SUPPORTED_MODE：指定支持的流复制模式。

* SUPPORTED_MODE_DESCR：显示支持的流复制模式描述。

使用Oracle GoldenGate，DBA可以在不同的数据库之间进行高性能，高可用性的流复制。 可支持的流复制模式有一致性，异步，HLOG，等。 DBA_GOLDENGATE_SUPPORT_MODE视图可以用来查看支持哪些流复制模式，并查找对应的描述。可以使用以下查询查看支持的模式及描述：

SELECT SUPPORTED_MODE, SUPPORTED_MODE_DESCR
FROM DBA_GOLDENGATE_SUPPORT_MODE;

官方英文解释

DBA_GOLDENGATE_SUPPORT_MODE displays information about the level of Oracle GoldenGate capture process support for the tables in the database.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Table owner

OBJECT_NAME

VARCHAR2(128)

Table name

SUPPORT_MODE

VARCHAR2(6)

Capture process support level for the table:

  • FULL – A capture process can capture changes made to all of the columns in the table

  • ID KEY – A capture process can capture changes made to the key columns and any other columns in the table supported by the capture process, except for LOB, LONG, LONG RAW, and XMLType columns.

  • INTERNAL – A capture process cannot capture changes made to any columns in the table because the table is secondary to a user-created table and is updated implicitly when changes are made to the user-created table. Such tables include mapping tables for index-organized tables, storage tables for nested tables, materialized view logs, secondary objects associated with domain indexes, and temporary tables.
  • PLSQL – A capture process can capture changes made to the table as long as Procedural Supplemental Logging is enabled on the source database. Such tables include hierarchy-enabled tables, AQ queue tables, and tables containing columns of type MDSYS.SDO_TOPO_GEOMETRY, MDSYS.SDO_GEORASTER, or MDSYS.SDO_RDF_TRIPLE_S.

  • NONE – A capture process cannot capture changes made to any columns in the table because the table is not supported for replication.

EXPLANATIONFoot 1

VARCHAR2(4000)

Reason the table does not have FULL capture process support

This column is populated only when both of the following conditions are met:

  • The value of the COMPATIBLE initialization parameter is 20.0 or higher
  • The value of the SUPPORT_MODE column is ID KEY, INTERNAL, PLSQL, or NONE

Footnote 1 This column is available starting with Oracle Database 21c.


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

相关推荐