Task 4: Prepare TimesTen Database for GoldenGate Replication

To prepare the TimesTen database for GoldenGate replication, few steps are required to ensure smooth and efficient data transfer between the source and target systems.

Note:

After installing GoldenGate, assign the necessary user privileges that are required for connecting to TimesTen database from Oracle GoldenGate to prepare the database for replication. For details, see TimesTen in the Microservices Architecture Documentation.

To prepare your database for GoldenGate replication:

  1. Use the Oracle GoldenGate Configuration Assistant (OGGCA) utility to create deployments and the Service Manager process on your host machine. Add a deployment using the OGGCA wizard and then create a Service Manager. For details, see Add a Deployment in the Microservices Architecture Documentation.
  2. Start the Service Manager. See Start and Stop the Service Manager in the Microservices Architecture Documentation.
  3. Start the Admin Client and then connect to your deployment, see About Admin Client in the Microservices Architecture Documentation.
  4. The Replicat is a process that delivers data to a target system. Before you begin adding a Replicat, make sure that the following settings are configured:
    • Add database connections
    • Add SCHEMATRANDATA

    For details, see Add a Replicat in the Microservices Architecture Documentation

  5. Create a parameter file for a Replicat and edit it (see Configure a Replicat Parameter File in the Microservices Architecture Documentation). In this example, edit the parameter file with the following content for setting up a Replicat:
    REPLICAT rep
TARGETDB cache1, USERID cacheadmin, PASSWORD ttpwd
MAP oratt.*, TARGET oratt.*

    Here oratt.* is the table owner and name on the source database, and oratt.* is the table owner and name in the TimesTen database. The table names should be same in both the source and the target databases. You can specify multiple MAP directives or use wildcards for multiple tables.

  6. Before you start a Replicat process, determine the current SCN value (see Task 5: Perform the Initial Data Load). Now, start a Replicat process and specify the SCN, see Stop, Start a Replicat in the Microservices Architecture Documentation.