X hits on this document

395 views

0 shares

1 downloads

0 comments

73 / 131

Replication should source from source server SRC and replicate in both STG1 and STG2 staging servers.

  • 1.

    Configure CDC for STG1 with the following configuration: SRC_OGG_OBJECT_GROUP = SRC SRC_SETUP_OGG_PROCESSES = YES STG_OGG_OBJECT_GROUP = STG1 STG_SETUP_OGG_PROCESSES = YES ENABLE_ODI_CDC= YES

  • 2.

    Start the journal and follow the instructions in the readme to set up the Oracle GoldenGate processes in SRC and STG1.

  • 3.

    Configure CDC for STG2 with the following configuration:

    • a.

      SRC_OGG_OBJECT_GROUP = SRC (Use the same name as for STG1)

    • b.

      SRC_SETUP_OGG_PROCESSES = NO (The processes have been set up with STG1)

    • c.

      STG_OGG_OBJECT_GROUP = STG2

    • d.

      STG_SETUP_OGG_PROCESSES = YES

    • e.

      ENABLE_ODI_CDC= YES

  • 4.

    Start the journal and follow the instructions in the readme to set up the Oracle GoldenGate processes in SRC and STG2. Note that playing the configuration on SRC again will not recreate a capture process, trail files, or definition files. It will simply create a new Oracle GoldenGate Datapump process to push data to STG2.

Knowledge Module Options Reference JKM Oracle to Oracle Consistent (OGG)

Option

VALIDATE

COMPATIBLE

LOCAL TEMP DIR

_

_

N B _ A P P L Y _ P R O C E S S

TRAIL FILE SIZE

_

_

SRC OGG OBJECT GROUP

_

_

_

SRC LSCHEMA

_

SRC DB USER

_

_

SRC DB PASSWORD

_

_

String

9

String

Default temp directory.

Number

1

Number

100

String

ODIS

String

<None>

String

<None>

String

<None>

Knowledge Modules Reference Guide

73/131

Values Yes|No

DB password of the source schema

DB user of the source schema

Logical schema of the source model.

Name of the source Oracle GoldenGate group

Trail file size in mega bytes.

Number of Replicat processes.

Full path to a temporary folder into which the Oracle GoldenGate configuration files will be generated.

RDBMS version compatibility

Default Value No

Description

Validates KM options and RDBMS version.

Document info
Document views395
Page views398
Page last viewedThu Dec 08 00:51:14 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments