Setting up the source database for use with Oracle GoldenGate - Strategies for Migrating Oracle Databases to AWS

Setting up the source database for use with Oracle GoldenGate

To replicate data to the destination database in AWS, you need to set up a source database for GoldenGate. Use the following procedure to set up the source database. This process is the same for both Amazon RDS and Oracle Database on Amazon EC2.

  1. Set the compatible parameter to the same as your destination database (for Amazon RDS as the destination).

  2. Enable supplemental logging and force logging.

  3. Verify the database is in archivelog mode.

  4. Set ENABLE_GOLDENGATE_REPLICATION parameter to TRUE.

  5. Set the retention period for archived redo logs for the GoldenGate source database.

  6. Create a GoldenGate user account on the source database.