Get the App
SLTechnology News&Howtos  ›  Database  › 

Steps for building OGG

Shulou Source: shulou.com Published: 2022-06-01 05:41:04 11月21日 Update

AIX-- > HP-UX

1. Download the GGS installation

Tar-xvf ggs_AIX_ppc_ora102_64bit_v11_1_1_0_0_078.tar

2, create a directory

GGSCI (test4-1541) 1 > create subdirs

3. Add additional logs on the source side

Database level:

SQL > alter database add supplemental log data

Table level:

GGSCI (test4-154) > dblogin userid goldengate,password goldengate

GGSCI (test4-154) > add trandata goldengate.TCU*

4. Configure the source-side mgr process

GGSCI (test4-154) > edit params mgr

PORT 7809

Dynamicportlist 7810-7815

Autostart extract *

Autorestart extract *, retries 5 and Waitless 7

Purgeoldextracts. / dirdat/et,usecheckpoints,minkeepdays 1

Lagreporthours 1

Laginfominutes 10

Lagcriticalminutes 15

5. Configure the EXTRACT process

GGSCI (test4-154) > add extract ext1,tranlog,begin now

GGSCI (test4-154) > add exttrail / ogg/dirdat/et, extract ext1,megabytes 50

EXTTRAIL added.

GGSCI (test4-154) 19 > edit params ext1

Extract ext1

Dynamicresolution

Userid goldengate, password goldengate

Exttrail / ogg/dirdat/jb

Table goldengate.TCUSTMER

Table goldengate.TCUSTORD

6. Configure the PUMP process

GGSCI (test4-154) 21 > add extract pump1,exttrailsource / ogg/dirdat/jb

EXTRACT added.

GGSCI (test4-154) 22 > add rmttrail / oracle/test/dirdat/et,extract pump1,MEGABYTES 50

RMTTRAIL added.

GGSCI (test4-154) 23 > edit params pump1

EXTRACT pmpjb

PASSTHRU

UserId goldengate, Password goldengate

RMTHOST 10.118.88.22, MGRPORT 7809

RMTTRAIL / oracle/test/dirdat/jb

Numfiles 50

DYNAMICRESOLUTION

TABLE goldengate.TCUSTMER

TABLE goldengate.TCUSTORD

7. Start the source-side process

GGSCI (test4-154) > start mgr

GGSCI (test4-154) > start *

-

EXP | IMP synchronizes data

-

8. Configure the target side mgr process

PORT 7809

Dynamicportlist 7810-7815w params mgr

Autorestart extract *, waitminutes 1 leading retries 5

Lagreporthours 1

Laginfominutes 3

Lagcriticalminutes 5

Purgeoldextracts / oracle/test/dirdat/jb*,usecheckpoints,minkeepdays 1

9. Add chkpoint to the destination side

GGSCI (HP-test1) 5 > edit params. / GLOBAL

GGSCHEMA goldengate

CHECKPOINTTABLE goldengate.ggschkpt

GGSCI (HP-test1) 9 > dblogin userid goldengate,password goldengate

GGSCI (HP-test1) 10 > add checkpointtable goldengate.ggschkpt

10, add replicat process

ADD REPLICAT rep_jb01,EXTTRAIL / oracle/test/dirdat/jb CHECKPOINTTABLE goldengate.ggschkpoint

11, start the target side process

Start mgr

Start rep_jb01 aftercsn xxxxx

Tags: Process configuration target data database log directory synchronization attach step Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi vpn Shulou Technology Huawei MySQL