goldengate(ogg)日常维护

 

1.修改复制进行的日志文件命名格式

ep修改为ap开头

GGSCI (epidbhn) 6> info repep

REPLICAT   REPEP     Last Started 2021-12-07 16:26   Status ABENDED
Checkpoint Lag       00:00:00 (updated 233:04:31 ago)
Log Read Checkpoint  File /u02/goldengate12c/dirdat/ep000000002
                     2021-12-07 17:39:40.983865  RBA 2223539



GGSCI (epidbhn) 8> alter repep,exttrail ./dirdat/ap

2021-12-17 10:49:32  INFO    OGG-06594  Replicat REPEP has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start REPEP with NOFILTERDUPTRANSACTIONS option.

REPLICAT altered.

GGSCI (epidbhn) 11> info repep

REPLICAT   REPEP     Initialized   2021-12-17 10:49   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:01:31 ago)
Log Read Checkpoint  File ./dirdat/ap000000000
                     First Record  RBA 0

 

2.查看投递进程日志保存的目录

 

GGSCI (ogg) 70> info extract dpep,detail 

EXTRACT    DPEP      Last Started 2023-03-06 01:02   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Process ID           11651
Log Read Checkpoint  File /goldengate19c/dirdat/ep000000014
                     2023-03-06 01:06:10.000000  RBA 29168

  Target Extract Trails:

  Trail Name                                       Seqno        RBA     Max MB Trail Type

  /goldengate19c/dirdat/pump103/ep                    17       3008        100 RMTTRAIL  

  Extract Source                          Begin             End             

  /goldengate19c/dirdat/ep000000014       2023-03-06 00:59  2023-03-06 01:06
  /goldengate19c/dirdat/ep000000014       2023-03-06 00:46  2023-03-06 00:59
  /goldengate19c/dirdat/ep000000014       2023-02-15 20:54  2023-03-06 00:46
  /goldengate19c/dirdat/ep000000013       2023-02-15 20:01  2023-02-15 20:54
  /goldengate19c/dirdat/ep000000013       2023-02-15 03:30  2023-02-15 20:01
  /goldengate19c/dirdat/ep000000012       2023-02-15 03:23  2023-02-15 03:30
  /goldengate19c/dirdat/ep000000012       2023-02-15 03:10  2023-02-15 03:23
  /goldengate19c/dirdat/ep000000012       2023-02-15 01:08  2023-02-15 03:10
  /goldengate19c/dirdat/ep000000010       2023-02-15 01:05  2023-02-15 01:08
  /goldengate19c/dirdat/ep000000010       2023-02-15 00:50  2023-02-15 01:05
  /goldengate19c/dirdat/ep000000010       2023-02-15 00:50  2023-02-15 00:50
  /goldengate19c/dirdat/ep000000010       2023-02-15 00:50  2023-02-15 00:50
  /goldengate19c/dirdat/ep000000010       2023-02-15 00:59  2023-02-15 00:50
  /goldengate19c/dirdat/ep000000010       * Initialized *   2023-02-15 00:59
  ./dirdat/ep000000000                    * Initialized *   First Record    


Current directory    /goldengate19c

Report file          /goldengate19c/dirrpt/DPEP.rpt
Parameter file       /goldengate19c/dirprm/dpep.prm
Checkpoint file      /goldengate19c/dirchk/DPEP.cpe
Process file         
Error log            /goldengate19c/ggserr.log

 

读取目录:/goldengate19c/dirdat

生成投递目录:/goldengate19c/dirdat/pump103/