This quick start guide helps you to get started with HVR for replicating data between Oracle databases.

To proceed with this replication you must have basic understanding about HVR's architecture and terminologies like Hub, Location, Channel, Location Groups, Actions etc.

The example here demonstrates how to replicate tables from one Oracle schema (source location) to another Oracle schema (target location).

In real-life scenarios, the source location(s) and the target location(s) reside on different machines and the HVR hub can reside on source or target or a separate machine. However, in this example, for simplicity we have the source, target, and HVR hub on the same machine i.e., a single Oracle instance with three schemas.

Before proceeding with this example ensure that the requirements for using HVR with Oracle are met.

Create Demo Schemas and Tables

The initial step of this demonstration is to create:

• a schema in the source location
• tables in the source schema (and insert values into these tables)
• a schema in the target location

Source Location

Skip this section if you already have a database with tables which you plan to use for this replication.

For this demonstration, in the source location, create a schema (e.g. sourcedb) with two tables (e.g. dm51_product and dm51_order), and insert values into these tables.

create table sourcedb.dm51_product 
(
 prod_id number(10) not null,
 prod_price number(10,2) not null,
 prod_descrip varchar2(100) not null,
 primary key (prod_id)
);

create table sourcedb.dm51_order 
(
 prod_id number(10) not null,
 ord_id number(10) not null,
 cust_name varchar2(100) not null,
 cust_addr varchar2(100),
 primary key (prod_id, ord_id)
);

Target Location

Create a schema (e.g. targetdb) in the target location.

Create Hub Database

Grants/Access Privileges

This section describes the grants/access privileges required for the source schema, target schema, and hub database.

1. Configure the privileges for source schema (sourcedb). For more information, see section Grants for Log-Based Capture in Requirements for Oracle.

   grant create session to sourcedb;
   grant create table to sourcedb;
   grant alter any table to sourcedb;
   grant select any dictionary to sourcedb;
   grant select any transaction to sourcedb;

2. Configure the privileges for target schema (targetdb). For more information, see section Grants for Integrate and Refresh in Requirements for Oracle.

   grant create session to targetdb;
   grant create table to targetdb;

3. Configure the privileges for hub schema (hvrhub). For more information, see section Grants for Hub Schema in Requirements for Oracle.

   grant create session to hvrhub;
   grant create table to hvrhub;
   grant create procedure to hvrhub;
   grant create trigger to hvrhub;
   grant execute on dbms_alert to hvrhub;

   A user with dba privileges should grant execute on dbms_alert to the hub database user (e.g. hvruser).

Download and Install HVR

Launch HVR GUI

Register Hub

Create Locations

This section describes how to create locations in HVR GUI. Location is a storage place (for example, database or file storage) from where HVR captures (source location) or integrates (target location) changes.

Create one source location (src) connected to source schema (sourcedb) and one target location (tgt) connected to target schema (targetdb).

1. In navigation tree pane, right-click Location Configuration ▶ New Location.
2. Enter Location name and Description for the location.
3. Select Oracle in Class.
4. Provide Database Connection details. For more information on Database Connection fields, see section Location Connection.
   1. Enter directory path for ORACLE_HOME. You can also click browse to select directory path.

   2. Enter Oracle System ID in ORACLE_SID or TNS credential or RAC credential.

      For RAC connectivity, ensure to provide remote machine connection details under Connection tab.

   3. Enter user name of schema in User. For example, sourcedb.
   4. Enter password for schema in Password. For example, hvr.
5. Click Test Connection to verify the connection to location database.
6. Click OK.
   

Create Channel

Create Location Groups

This section describes how to create location groups in a channel. The location groups are used for defining action on the location. Typically a channel contains two location groups - one for the source location and one for the target location. Each location group can contain multiple locations.

In this example, create one source location group (SRCGRP) and one target location group (TGTGRP).

1. In navigation tree pane, click + next to the channel (hvrdemo).
2. Create source location group (SRCGRP):
   1. Right-click Location Groups ▶ New Group.
   2. Enter Group Name and Description for the location group.
   3. Select source location (src) from Group Membership.
      
   4. Click OK.
3. Create target location group (TGTGRP):
   1. Right-click Location Groups ▶ New Group.
   2. Enter Group Name and Description for the location group.
   3. Select target location (tgt) from Group Membership.
      
   4. Click OK.

Select Table(s)

This section describes how to select the tables (dm51_product and dm51_order) from source location for replication. Table Explore allows you to select schema(s) and/or table(s) for replication.

1. Right-click Tables ▶ Table Explore.
2. Select source location (src) from the list.
   
3. Click Connect.
4. Select tables from Table Explore dialog. Press Shift key to select multiple tables or Ctrl+A to select all tables.
5. Click Add to add the selected tables.
6. Click OK in HVR Table Name dialog.
7. Click Close in Table Explore dialog.
   

Define Actions

This section describes how to define Actions on the location groups (SRCGRP and TGTGRP). Actions define the behavior of a replication activity.

1. Define action Capture to capture changes from all tables in the source location group.
   1. Right-click source location group SRCGRP ▶ New Action ▶ Capture.
      
   2. Click OK.
2. Define action Integrate.
   1. Right-click target location group TGTGRP ▶ New Action ▶ Integrate.
      

   2. Click OK.

Initialize

Start Scheduler

Start Capture Job

Refresh

This section describes how to perform initial load into the target database. HVR Refresh copies all existing data from source location (src) to the target location (tgt) and optionally creates new tables and keys in target location.

1. In the navigation tree pane, right-click channel hvrdemo ▶ HVR Refresh.
2. Select Create Absent Tables in HVR Refresh dialog.
   
3. Click Refresh.
4. Click Yes to begin HVR Refresh.
   When the refresh is completed, the Refresh Result dialog displays the total number of rows replicated from the selected tables.
   
5. Click Close in Refresh Result dialog.
6. Click Close in HVR Refresh dialog.

Start Integrate Job

Verify Replication

This section describes the two methods for verifying HVR's replication activity.