使用OGG的logdump工具检查OGGtrailfile中存在不存在相关表的记录

2015-11-21 01:54:01 · 作者: · 浏览: 4

OGG和logdump工具的关系,类似于Oracle Database 和logminer工具的关系。

$ logdump

Oracle GoldenGate Log File Dump Utility for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

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

Logdump 823 >open /u02/ggs/dirdat/ab123456
Current LogTrail is /u02/ggs/dirdat/ab123456 
Logdump 824 >ghdr on
Logdump 825 >detail on
Logdump 826 >detail data
Logdump 827 >ggstoken on
Logdump 828 >usertoken on
Logdump 829 >ggstokens detail
Logdump 830 >filter include filename USERA.TEST_TABLE_1 --->
注意点:USERA不能少!用户名和表名该用大写的时候一定要用大写。 Logdump 831 >n Scanned 10000 records, RBA 2583311, 2015/08/13 02:49:23.000.000 Scanned 20000 records, RBA 4583594, 2015/08/13 02:49:23.000.000 Scanned 30000 records, RBA 6643110, 2015/08/13 03:00:17.000.000 ---->如上三行表示没有找到涉及到USERA.TEST_TABLE_1的sql语句。 Filtering suppressed 32621 records Logdump 832 >nt ---------------->nt是next trail的缩写。 LogTrail /u02/ggs/dirdat/ab123456 closed Current LogTrail is /u02/ggs/dirdat/ab123457 Logdump 833 >n Filtering suppressed 7747 records Logdump 834 >

?