After the initial configuration of a logical standby database, we should make customizations to benefit from the standby at the highest level. Let's see what kind of customizations we are able to do and how we manage a logical standby database environment.
In principle, we cannot directly specify what to replicate to a logical standby database, but we can specify tables for SQL Apply to
skip. When this feature is used, the redo data about the tables specified in the
skip rules is still transferred to the standby database, but at the mining stage SQL Apply will omit the relevant redo on the logical standby. We use
DBMS_LOGSTDBY.SKIP for ...