ogg一些诊断技巧

ogg问题诊断：
1.在复制进程中加入参数，可以跟踪相关的操作
GGSCI (lxtrac03.iris.cl.sh.cos) 1> view params reputest

REPLICAT REPUTEST
setenv (NLS_LANG="AMERICAN_AMERICA.UTF8")
USERID goldengate@clone, PASSWORD goldengate
ASSUMETARGETDEFS
DISCARDFILE /u01/goldengate/dirrpt/reputest.dsc,PURGE
--NODYNSQL
--NOBINARYCHARS
--SHOWSYNTAX
--GROUPTRANSOPS 1
--MAXTRANSOPS 1
--HANDLECOLLISIONS
MAP SCOTT.EMP, TARGET SCOTT.EMP;
MAP SCOTT.DEPT, TARGET SCOTT.DEPT;
MAP SCOTT.BONUS, TARGET SCOTT.BONUS;
MAP SCOTT.EMP1, TARGET SCOTT.EMP1;

SQLEXEC "ALTER SESSION SET TRACEFILE_IDENTIFIER='OGG_DEBUG'"
SQLEXEC "ALTER SESSION SET EVENTS '10046 trace name context forever, level 12'"

GGSCI (lxtrac03.iris.cl.sh.cos) 2>

参考资料：Replicat Abends with Error OGG-01082 Call To The Dboci_Check_For_Virtual_Column: Oci Error (100-Ora-01403: No Data Found) Determining If Column Is Virtual (文档 ID 1556577.1)

2.查看mgr，purge的trial文件路径是否正确。

GGSCI (lxtrac05) 10> send mgr, getpurgeoldextracts

Sending GETPURGEOLDEXTRACTS request to MANAGER ...

PurgeOldExtracts Rules
Fileset MinHours MaxHours MinFiles MaxFiles UseCP
/tt/dirdat/* 3 0 1 0 Y
OK
Extract Trails
Filename Oldest_Chkpt_Seqno IsTable IsVamTwoPhaseCommit
/tt/dirdat/e1 1

GGSCI (lxtrac05) 11>

3.查看投递进程，和抽取进程的路径及文件

GGSCI (lxtrac05) 1> info rmttrail *
Extract Trail: /home/ggate/goldengate/dirdat/e1
Extract: DMPU1
Seqno: 231972
RBA: 2298887
File Size: 100M
Extract Trail: /home/gggate/goldengate/dirdat/e6
Extract: EXTU6
Seqno: 428431
RBA: 27160018
File Size: 100M
GGSCI (lxtrac05) 2>

4.善用 REPERROR(1403,ignore)

GGSCI (lxpdtsora2.iris.cl.sh.cos) 9> view params repudts

REPLICAT REPUDTS
USERID goldengate, PASSWORD goldengate
ASSUMETARGETDEFS
DISCARDFILE /data/goldengate12c/dirrpt/repudts.dsc,PURGE
DISCARDFILE /data/goldengate12c/discard/repudts.dsc
SOURCECHARSET utf8
--NODYNSQL
--NOBINARYCHARS
--SHOWSYNTAX
DBOPTIONS NOSUPPRESSTRIGGERS
--GROUPTRANSOPS 1
--MAXTRANSOPS 1
REPERROR(1403,ignore)
--HANDLECOLLISIONS
MAP BD_MAINT.BD_CGO_BRIEF_DESC, TARGET DTS_MAINT.BD_CGO_BRIEF_DESC, KEYCOLS (BD_CGO_BRIEF_DESC_UUID);