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

来源：互联网发布：软件编程成果展板编辑：程序博客网时间：2024/05/23 23:04

本文是原创文章，转载请务必注明出处，否则谢绝转载：http://blog.csdn.net/msdnchina/article/details/47625661

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

$ logdumpOracle GoldenGate Log File Dump Utility for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.Logdump 823 >open /u02/ggs/dirdat/ab123456Current LogTrail is /u02/ggs/dirdat/ab123456 Logdump 824 >ghdr onLogdump 825 >detail onLogdump 826 >detail dataLogdump 827 >ggstoken onLogdump 828 >usertoken onLogdump 829 >ggstokens detailLogdump 830 >filter include filename USERA.TEST_TABLE_1 --->注意点：USERA不能少！用户名和表名该用大写的时候一定要用大写。Logdump 831 >nScanned     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 >nFiltering suppressed   7747 records Logdump 834 >

0 0