Oracle 视图 DBA_LOGSTDBY_UNSUPPORTED 官方解释，作用，如何使用详细说明
本站中文解释
_COL？
Oracle视图DBA_LOGSTDBY_UNSUPPORTED_COL用于检查存储在归档日志中的要同步到物理故障转移（ Standby） 的不受物理故障转移（Standby） 支持的列，此外，该视图还会列出这些列的归档日志范围。
它的主要用途是用于检查指定表中有哪些不受物理故障转移（ Standby） 所支持的列，以及它们受到影响的归档日志范围。它可以帮助DBA 们在物理故障转移（Standby）系统中找出不能同步的列，以及这些列所影响的归档日志范围，从而避免出现数据同步异常。
使用方法：
select owner, segment_name, segment_type, column_name, unsupported_reason, start_scn, end_scn
From Dba_Logstdby_Unsupported_Col;
此查询将显示未支持的列的所有信息，包括所有者名称、片段名称、片段类型、列名称、未支持的原因、起始SCN和终止SCN。
官方英文解释
DBA_LOGSTDBY_UNSUPPORTED displays the schemas, tables, and columns in those tables that contain data types that are unsupported by logical standby.
The query results for this view depend on whether the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases. If the database is undergoing such an upgrade, then this view displays information about tables in the database that are unsupported for transient logical standby. If the database is not undergoing such an upgrade, then this view displays information about tables in the database are unsupported for logical standby.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the unsupported table |
|
|
|
|
Name of the unsupported table |
|
|
|
|
Name of the unsupported column |
|
|
|
|
If the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases and the value of the |
|
|
|
|
Data type of the unsupported column |
Note:
When the value of the COMPATIBLE initialization parameter is 20.0 or higher, this view displays all columns in unsupported tables. Otherwise, this view displays only the unsupported columns in unsupported tables.
Note:
A rolling upgrade performed using the DBMS_ROLLING PL/SQL package supports more object types than a manual rolling upgrade performed using transient logical standby databases.
See Also:
-
“DBA_ROLLING_UNSUPPORTED” for more information about determining unsupported data types for a rolling upgrade using the
DBMS_ROLLINGpackage -
Oracle Data Guard Concepts
and Administration for more information about rolling operations -
Oracle Data Guard Concepts
and Administration for more information about unsupported tables for rolling upgrade operations -
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_ROLLINGpackage
