EXECUTE DBMS_LOGSTDBY.BUILD

最新推荐文章于 2025-09-30 09:49:24 发布

转载最新推荐文章于 2025-09-30 09:49:24 发布 · 220 阅读

本文介绍如何通过执行DBMS_LOGSTDBY.BUILD过程来构建LogMiner字典，这是确保SQL Apply组件正确解析redo日志中变更的关键步骤。补充日志会自动设置以记录主键及唯一约束/索引列。

4.2.3.2 Build a Dictionary in the Redo Data
A LogMiner dictionary must be built into the redo data so that the LogMiner component of SQL Apply can properly interpret changes it sees in the redo. As part of building LogMiner Multiversioned Data Dictionary, supplemental logging is automatically set up to log primary key and unique-constraint/index columns. The supplemental logging information ensures each update contains enough information to logically identify each row that is modified by the statement.

To build the LogMiner dictionary, issue the following statement:

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
The DBMS_LOGSTDBY.BUILD procedure waits for all existing transactions to complete. Long-running transactions executed on the primary database will affect the timeliness of this command.

The DBMS_LOGSTDBY.BUILD procedure uses Flashback Query to obtain a consistent snapshot of the data dictionary that is then logged in the redo stream. Oracle recommends setting the UNDO_RETENTION initialization parameter to 3600 on both the primary and logical standby databases.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-677569/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-677569/