You can use Oracle GoldenGate, Oracle XStreams, Oracle Data Guard, or Oracle Active Data Guard to replicate tables that have columns containing JSON data. You can also use Oracle GoldenGate to replicate JSON-relational duality views.

In particular, you can replicate textual JSON data (VARCHAR2, CLOB, or BLOB) in the primary server to JSON type data in the secondary. You can also replicate textual data to textual data or JSON type data to JSON type data.

All indexes on the JSON data are also replicated also. However, on the replica database, you must carry out any Oracle Text operations that you use to maintain a JSON search index. Here are examples of such procedures:

• CTX_DDL.sync_index

• CTX_DDL.optimize_index

Be aware that Oracle GoldenGate requires tables that are to be replicated to have a nonvirtual primary key column; the primary key column cannot be virtual.