Primary Oracle Database Configuration for Replication

Configure the primary Oracle database for replication and to ensure that the Oracle redo log data is not overwritten before it is read by the Replication Agent.

• Verifying the Current Archive Setting of the Redo Logs
  Verify that redo logging, which Oracle uses to maintain a log infrastructure, is turned on. Turn redo logging on only in the primary database.
• Verifying the Supplemental Logging of Primary Key Data
  Verify that Oracle logs the values of the primary keys and unique indexes.
• Creating Oracle User and Grant Permissions
  Create an Oracle database user for use by Replication Agent when connected to the primary database.
• Verifying the Oracle User Roles Created by the Replication Agent
  Validate the required Oracle settings.