Ogg Initialization Process Configuration

The online search for "ogg configuration" is basically a configuration process, with less technical documentation for the Ogg initialization process. The general Ogg initialization is mainly divided into two types, one is that the source database table column does not contain the CLOB type, and the other case is that the source database table column contains the CLOB type.

The test here is: source database table is source.test1, destination IP is 192.168.100.20,ogg user and password is ogg,ogg, destination database instance is ORCL

mode one (for databases that do not contain CLOB data types)

1. Source-side Initialization process configuration
ADD EXTRACT ini_1,sourceistable
EDIT PARAMS ini_1

EXTRACT ini_1

SETENV (Nls_lang=american_america. ZHS16GBK)
USERID ogg, PASSWORD ogg
rmthost 192.168.100.20,mgrport 7809
rmttask replicat, GROUP rini_1
TABLE Source.test1;
2. Destination initialization process Configuration
ADD replicat Rini_1,specialrun
EDIT PARAMS rini_1

Replicat rini_1
SETENV (Nls_lang=american_america. ZHS16GBK)
Assumetargetdefs
USERID Tfogg, PASSWORD ogg
discardfile./dirrpt/rini1aa.dsc,purge
MAP source.test,target destination.test;
Note: You can synchronize more than one table at a time

Mode two (suitable for databases that contain CLOB data types):

1. Remote configuration:
ADD EXTRACT ini_2,sourceistable
EDIT PARAMS ini_2

EXTRACT ini_2
SETENV (Nls_lang=american_america. ZHS16GBK)
USERID ogg, PASSWORD ogg
rmthost 192.168.100.20,mgrport 7809
rmtfile./dirdat/ti,maxfiles 999999,megabytes
TABLE source.test;

2. Destination-side configuration:

dblogin USERID Ogg,password OGG

ADD checkpointtable OGG. Init_ckpt

ADD replicat rep9,exttrail./dirdat/ti,checkpointtable OGG. Init_ckpt

EDIT PARAM REP9

    Replicat rep9
SETENV (ORACLE_SID=ORCL)
SETENV (Nls_lang = "American_america. ZHS16GBK ")
USERID Ogg,password ogg
Reportcount every MINUTES, rate
reperror DEFAULT, ABEND
Numfiles
handlecollisions
Assumetargetdefs
discardfile/DIRRPT/REP9.DSC, APPEND, megabytes.
allownoopupdates
MAP source.test, TARGET destination.test;

Note: Only one table can be synchronized at a time

Reference URL:

Ogg Initialization Process Configuration