OGG 跳过错误事务

最新推荐文章于 2025-03-28 14:58:28 发布

RookieDBA

最新推荐文章于 2025-03-28 14:58:28 发布

阅读量5k

点赞数

分类专栏： GoldenGate 文章标签： Oracle GoldenGate

本文链接：https://blog.youkuaiyun.com/a5546868001/article/details/81188339

版权

GoldenGate 专栏收录该内容

2 篇文章

订阅专栏

跳过错误的事务：

[oracle@ince ogg]$ ./logdump 

Oracle GoldenGate Log File Dump Utility for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.



Logdump 7 >open /u01/ogg/dirdat/ps000000000
Current LogTrail is /u01/ogg/dirdat/ps000000000 
Logdump 8 >pos 2506
Reading forward from RBA 2506 
Logdump 9 >n

2018/07/20 13:58:18.495.377 Insert               Len    78 RBA 2506 
Name: OGG_OWNER.TOGG  (TDR Index: 1) 
After  Image:                                             Partition 12   G  s   
 0000 0008 0000 0004 3130 3033 0001 0004 ffff 0000 | ........1003........  
 0002 0004 ffff 0000 0003 0015 ffff 3139 3030 2d30 | ..............1900-0  
 312d 3031 3a30 303a 3030 3a30 3000 0400 15ff ff31 | 1-01:00:00:00......1  
 3930 302d 3031 2d30 313a 3030 3a30 303a 3030      | 900-01-01:00:00:00  

Logdump 10 >n
Logdump 14 >n

2018/07/20 14:09:00.506.794 Insert               Len    78 RBA 2688 
Name: OGG_OWNER.TOGG  (TDR Index: 1) 
After  Image:                                             Partition 12   G  s   
 0000 0008 0000 0004 3130 3034 0001 0004 ffff 0000 | ........1004........  
 0002 0004 ffff 0000 0003 0015 ffff 3139 3030 2d30 | ..............1900-0  
 312d 3031 3a30 303a 3030 3a30 3000 0400 15ff ff31 | 1-01:00:00:00......1  
 3930 302d 3031 2d30 313a 3030 3a30 303a 3030      | 900-01-01:00:00:00  

[oracle@ince ogg]$ ./ggsci 

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.



GGSCI (ince) 1> alter replicat rsydb001 ,extrba 2688

2018-07-20 14:10:10  INFO    OGG-06594  Replicat RSYDB001 has been altered through GGSCI. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start RSYDB001 with NOFILTERDUPTRANSACTIONS option.

REPLICAT altered.


GGSCI (ince) 2> start rsydb001

Sending START request to MANAGER ...
REPLICAT RSYDB001 starting


GGSCI (ince) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     RSYDB001    00:00:00      00:00:00    
 alter replicat imp1 , extrba 5235