Create an Active-Active Database Replication

Learn to use an Active-Active database replication recipe to create a bidirectional replication process in Oracle GoldenGate Free.

Description of the illustration active-active-regions.png

Before you begin

To succesfully complete this Quickstart, you need:

• Source and target databases with sample data loaded.
• GoldenGate Free installed and configured.

Task 1: Create the database connections

1. Create the source connection:
   1. On the GoldenGate Free Home page, click Create connection.
   2. On the General Information page, for Name, enter sourceDB, optionally enter a description, and then click Next.
   3. On the Connection details page, complete the following field, and then click Next:
      • For Connection details, click Source.
      • For Connection type, select Basic from the dropdown.
      • For Hostname, enter the hostname.
      • For Port, enter 1521.
      • For Database type, select the option that fits your database version and complete the fields as needed.
      • For Pluggable database service name (PDB), enter the PDB name.
      • Select SYSDBA privileges available. An Administrator Credentials pop up will appear. Complete the following fields, and then click OK.
        • For User with admin privilege, enter sys or system.
        • For Password for admin user, enter the password for the sys user.
   4. On the GoldenGate admin user page, add GoldenGate admin database user:
      • Select Add GoldenGate admin database user.
      • For User with admin privilege, enter one of the following:
        • For Oracle 21c or above, enter ggadmin
        • For Oracle 19c or earlier, enter c##admin
        • For Non-container database, enter ggadmin
      • For Password, enter a password.
   5. On the Configuration page, follow the instructions below, and then click Next :
      • Select SYSDBA privileges available.
      • Click Run analysis.
      • Review the script by scrolling through and reviewing it completely. Select I have reviewed the SQL script and am aware of the changes it will apply to my database.
      • Click Run SQL.
      • Review the Prepare database result. Click OK.
   6. On the Confirmation page, review the details, and then click Create.
2. Repeat the steps above to create the target connection, and make these changes:
   • On the General Information page, for Name, enter targetDB.
   • On the Connection details page, for Connection details, click Target.

Task 2: Create and configure the pipeline

1. Create the pipeline:
   1. On the GoldenGate Free Home page, click Create pipeline.
   2. On the Recipe page, select the Active-active Database Replication recipe, and then click Next.
   3. On the Overview page, for Name, enter demo-pipeline, optionally enter a description, and then click Next.
   4. On the Connections page:
      1. For Source database, select the source database from the dropdown.
      2. For Target database, select the target database from the dropdown.
   5. Click Save & configure.
2. Configure the pipeline:
   1. On the Configuration page, for Mapping, deselect PDBADMIN so that HR is the only Source Schema selected. Click Save.

      Note:

      • This assumes you're using demo data provided by Oracle. If using your own data, configure the schema and table mappings as needed.
      • You can also configure Automatic Conflict Detection Resolution (ACDR) for specific tables. Learn more.
   2. On the Overview page, in the Initialization view, click Start.

      Note:

      It takes a few minutes for the pipeline initialization to run. The status of each of the steps will change from PENDING to IN PROGRESS to COMPLETED when it is ready for you to use.
   3. In the Runtime view, you can view the real time database statistics, such as Operations Extract and Operations Replicat.

Task 3: Monitor the pipeline

1. Monitor the pipeline in the GoldenGate Free console.
2. For advanced monitoring, you can review the Extracts and Replicats the GoldenGate Microservices console.