June 2013
Beginner
404 pages
9h 40m
English
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 ...
Read now
Unlock full access