This whitepaper is for historical reference only. Some content might be outdated and some links might not be available.
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.
-
Set the compatible parameter to the same as your destination database (for Amazon RDS as the destination).
-
Enable supplemental logging and force logging.
-
Verify the database is in
archivelog
mode. -
Set
ENABLE_GOLDENGATE_REPLICATION
parameter toTRUE
. -
Set the retention period for archived redo logs for the GoldenGate source database.
-
Create a GoldenGate user account on the source database.