1.查看状态 GGSCI (memogg0501kf as c##ggadm@STUTF1/CDB$ROOT) 36> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING JAGENT RUNNING PMSRVR RUNNING EXTRACT ABENDED EXTPDK10 00:00:02 19:14:29

2.查看报错信息 GGSCI (memogg0501kf as c##ggadm@STUTF1/CDB$ROOT) 37> view report EXTPDK10

2022-06-16 16:30:25 ERROR OGG-02028 Failed to attach to logmining server OGG$EXTPDK10 error 1,292 - ORA-01292: LogMiner for upstream capture cannot find log file.

2022-06-16 16:30:25 ERROR OGG-01668 PROCESS ABENDING.

报错信息显示找不到用于上游捕捉的logminer日志

3.查看信息 GGSCI (memogg0501kf as c##ggadm@STUTF1/CDB$ROOT) 38> view params EXTPDK10

EXTRACT EXTPDK10 USERID c##ggadm@C06U30ST_ogg PASSWORD Cmb#2020 TRANLOGOPTIONS CHECKPOINTRETENTIONTIME 1 TRANLOGOPTIONS ASYNCTRANSPROCESSING 1024 TRANLOGOPTIONS _READAHEADCOUNT 64

EXTTRAIL /u01/app/replicat/dirdat/a8

CACHEMGR CACHESIZE 4GB REPORTCOUNT EVERY 1 MINUTES, RATE TRANLOGOPTIONS EXCLUDETAG 00 DISCARDFILE ./dirrpt/EXTPDK10.dsc, APPEND, MEGABYTES 1024 DISCARDROLLOVER AT 6:00 WARNLONGTRANS 1h, CHECKINTERVAL 5m, SKIPEMPTYTRANS

DDL INCLUDE MAPPED SOURCECATALOG PDKTRX05 TABLE PDKTRX05.PDK_TFN_PZC_T;

4.登录数据库 dblogin USERID c##ggadm@C06U30ST_ogg PASSWORD Cmb#2020

5.如果是ds库，先登录源库再登录ds库 miningdblogin USERID c##ggadm@C06U30ST_ogg PASSWORD Cmb#2020

6.取消注册 unregister extract EXTPDK10 database

7.从前时间点重新抽数，重新注册 alter extract EXTPDK10 begin now register extract EXTPDK10 database container (PDKTRX05)

8.启动进程 start EXTPDK10

9.检查进程状态，等待同步 info all