Customization and management in a logical standby database
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.
Selective replication in a logical standby database
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 this purpose.
