LINUX 5.8, OGG 12.2.1
1 原端的抓取进程参数,投递进程参数,及生成的TRAIL文件
GGSCI (oracle2mysql) 80> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPE_C2U1 00:00:00 00:00:02
EXTRACT RUNNING EXT_C2U1 00:00:00 00:00:00
GGSCI (oracle2mysql) 81> view param ext_c2u1
EXTRACT ext_c2u1
SETENV (ORACLE_SID=deer)
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid ogg_user, password 1
REPORTCOUNT EVERY 1 MINUTES, RATE
numfiles 5000
DISCARDFILE ./dirrpt/ext_c2u1.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER AT 3:00
exttrail ./dirdat/r1, megabytes 100
dynamicresolution
TRANLOGOPTIONS EXCLUDEUSER ogg_user
TABLE C2U.*;
GGSCI (oracle2mysql) 82> view param dpe_c2u1
EXTRACT DPE_C2U1
dynamicresolution
passthru
rmthost 172.16.2.122, mgrport 7809, compress
rmttrail ./dirdat/t1
numfiles 5000
TABLE C2U.*;
GGSCI (oracle2mysql) 83>
$ls -lrt
total 115596
-rw-r----- 1 oracle oinstall 1398 Mar 7 16:03 r1000000
-rw-r----- 1 oracle oinstall 1461 Mar 7 16:04 r1000001
-rw-r----- 1 oracle oinstall 13690621 Mar 7 16:56 r1000002
-rw-r----- 1 oracle oinstall 4558306 Mar 7 17:37 r1000003
-rw-r----- 1 oracle oinstall 99972413 Mar 8 18:04 r1000004
[oracle@oracle2mysql /app/ogg/12.2.1/dirdat]
2 目标端的REPLICAT 进程参数,及生成的TRAIL文件,文件尺寸为0;
GGSCI (ora101) 42> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_C2U1 00:00:00 00:00:03
GGSCI (ora101) 44> view params mgr
PORT 7809
GGSCI (ora101) 45> view param rep_c2u1
REPLICAT rep_c2u1
SETENV (ORACLE_SID=lion)
SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
USERID ogg_user, PASSWORD 1
REPORTCOUNT EVERY 30 MINUTES,RATE
REPERROR DEFAULT, ABEND
numfiles 5000
assumetargetdefs
DISCARDFILE ./dirrpt/rep_c2u1.dsc.dsc,APPEND,MEGABYTES 100
ALLOWNOOPUPDATES
MAP C2U.*, TARGET C2U.*;
GGSCI (ora101) 46>
[oracle@ora101 /app/ogg/12.2.1/dirdat]
$ls -lrt
total 0
-rw-r----- 1 oracle oinstall 0 Mar 8 17:57 t1000000
[oracle@ora101 /app/ogg/12.2.1/dirdat]