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). This example shows how to 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 to avoid errors. You can specify multiple MAP directives or use wildcards for multiple tables.

  6. Start the Replicat process from the specified SCN.

    Note:

    When multiple log-based read-only cache groups exist, you must use the lowest SCN across all of them.

    For example, to get the initial load SCN, you can either run the cachegroups command (see Step3c to Step3e in ) or the system view command on your TimesTen that shows the current status of cache group loading operations: 

    Command> describe sys.v$cache_group_load_status;
View SYS.V$CACHE_GROUP_LOAD_STATUS:
Columns:
CACHE_GROUP_OWNER TT_CHAR (31) NOT NULL
CACHE_GROUP_NAME TT_CHAR (31) NOT NULL
MINIMUMLOADSCN CHAR (20)

Command> select * from sys.v$cache_group_load_status order by customer_orders;
< cacheadmin , customer_orders , 1827747 >
1 row found.

    To start a Replicat process starting from the SCN, see Stop, Start a Replicat in the Microservices Architecture Documentation.