A: Use GoldenGate’s built-in compression and encryption. Always transfer trails with guaranteed delivery (e.g., using OGG’s TCP/IP remote trail option with acknowledgment).

You lose exactly one transaction. You must manually reconcile that row(s) later.

When faced with OGG-01184, the standard action recommended by Oracle is to , as the trail may be irrecoverably corrupted. However, seasoned DBAs often use the following manual recovery steps:

Stop Pump and Extract temporarily. Step 3: Copy the archived clean trail ( rt000011 and clean portion of rt000012 from backup) into place. Step 4: Restart Extract with BEGIN NOW or from a known restart point. Step 5: Restart Pump and Replicat.

Note the last valid record position. Then attempt to go beyond it: