How Does HVR Deal With Non-Logged Unrecoverable Operations

Question

How does HVR deal with non-logged unrecoverable operations, such as direct-path inserts (insert /*+ APPEND */) above the High Water Mark (HWM) into NOLOGGING tables?

HVR supports the capture of direct-path/append-hint/parallel inserts to regular tables, but the tables defined as NOLOGGING are not supported.

Environment

HVR 5

Answer

When a direct path operation is performed on a table that is defined as NOLOGGING and the database is not in a force logging mode, generally the changes are silently ignored.

These direct path changes in Oracle are not recoverable.

If direct path operations on tables with NOLOGGING occur on the source (and they can't be avoided), you can schedule an online refresh after they happen.