Oracle 视图 DBA_LOGSTDBY_SKIP 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_LOGSTDBY_SKIP是DBA用来控制Data Guard管理过程中跳过特定日志块的视图，可以将其认为是一种安全机制来操作Data Guard。用户可以在主库上使用DBA_LOGSTDBY_SKIP视图来查看哪个日志块被跳过，当一次redo传送失败时，从库中具有跳过日志块的概念，允许用户指定在每次传送到从库之前都要跳过特定日志块。
使用DBA_LOGSTDBY_SKIP视图，首先用户需要在主库中创建一个用于跳过特定日志的表，然后将需要跳过的日志信息插入其中，并且开启apply process的相关参数；此外，通过DBA_LOGSTDBY_SKIP视图也可以查看Data Guard记录跳过日志的信息，以及添加或删除日志跳过的块，因此也可以作为一种监控工具，用来发现哪些日志被跳过了，对于有重要变化的项目，可以及时进行处理以确保可用性。
官方英文解释
DBA_LOGSTDBY_SKIP displays the skip rules that are used by SQL Apply.
This view is for logical standby databases only.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Indicates how the skip rule was created:
|
|
|
|
|
Specifies the type of statement that should be skipped |
|
|
|
|
Name of the schema under which the skip option should be used |
|
|
|
|
Name of the object that is being skipped |
|
|
|
|
Indicates whether the statement should use a SQL wildcard search when matching names ( |
|
|
|
|
Escape character used when performing wildcard matches |
|
|
|
|
Name of a stored procedure that will be executed when processing the skip option |
See Also:
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_LOGSTDBY.SKIP_ERRORprocedure -
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_LOGSTDBY.SKIPprocedure
