Marking and unmarking tables

To replicate transactions that affect the data in a table in the primary database, that table must be marked for replication, and replication must be enabled for the marked table.

Marking a table can be separate from enabling replication for that table. If the value of the pdb_dflt_object_repl parameter is true, replication is enabled automatically at the time a table is marked. For more information, see “Enabling and disabling replication for marked tables”.

NoteBy default, Mirror Replication Agent will mark and enable user tables and their LOB columns for replication when the Mirror Replication Agent is initialized using the ra_init command.If this is not the default behavior desired, you can turn off automatic marking of tables using the pdb_automark_tables configuration parameter.

Table marking with Mirror Replication Agent

When a table is marked for replication, the Mirror Replication Agent does the following:

When a table is marked and enabled, any subsequent operations that affect the data in that table are replicated.

Table unmarking with Mirror Replication Agent

When you unmark a table marked for replication, the Mirror Replication Agent does the following:

When a table is unmarked, any subsequent operations that affect the data in that table are ignored (not replicated).