Skip to main content

What's replicated, what's not?

Logged operations are replicated. These include, but are not limited to:
  • DDL
  • DML
  • Create/alter table space
  • Create/alter storage group
  • Create/alter buffer pool
  • XML data.
  • Logged LOBs
Not logged operations are not replicated. These include, but are not limited to:
  • Database configuration parameters (this allows primary and standby databases to be configured differently).
  • "Not logged initially" tables
  • Not logged LOBs
  • UDF (User Defined Function) libraries. UDF DDL is replicated. But the libraries used by UDF (such as C or Java libraries)  are not replicated, because they are not stored in the database. Users must manually copy the libraries to the standby.
Note: You can use database configuration parameter BLOCKNONLOGGED to block not logged operations on the primary.

Comments