Logdump 分析队列文件

Logdump　分析队列文件

 

1 Run the LogDump program from the GoldneGate installation location.

oracle@Z813:/u01/ggs> ./logdump

 

GoldenGate Log File Dump Utility

Version 10.0.0.13 Build 001

 

2 Set up the view. 建立环境

2.1 To view the record header with the data:

Logdump 1 >ghdr on

 

2.2 To add column information

Logdump 2 >detail on

Column information includes the number and length in hex and ASCII.

 

2.3 To add hex and ASCII data values to the column information:

Logdump 3> DETAIL DATA

 

2.4. To view user tokens:

Logdump 4> USERTOKEN ON

 

2.5. To control how much record data is displayed:

Logdump 5> RECLEN

 

3 To open a trail file　打开文件

3.1 Logdump 5 >open /u01/ggs/dirdat/ex000019

Current LogTrail is /u01/ggs/dirdat/ex000019

 

3.2. To go to the first record and then move through records in sequence:

Logdump 7> NEXT      or N

 

4 To go to a specific RBA in the file 定位

 

4.1 To go to an RBA anywhere in the file:

Logdump 35> POS

Logdump 36> N

 

 

4.2 To go to the first record in the file:

Logdump 37> POS FIRST

or...

Logdump 37> POS 0

 

5 To filter based on a table name

 

5.1 To filter out everything except records containing a specific table name:

 

Logdump 60> FILTER INCLUDE/EXCLUDE FILENAME .

 

Now, when you use the N command, you will only see records that satisfy this

filter.

 

5.2 To remove the current filter criteria

 

Logdump 62> FILTER CLEAR

 

5.3 To filter on multiple conditions

Logdump 65> FILTER INCLUDE FILENAME .

; FILTER RECTYPE

; FILTER MATCH ALL

 

6 To count the records in a trail file

Logdump 67> COUNT

 

7 To save records to a new trail file

7.1 To save the whole file:

Logdump 68> SAVE

Where: is the name of the new file.

 

7.2 To save a subset of records:

Logdump 69> SAVE RECORDS

To close the current file and open the next one in the trail

Logdump 70> NEXTTRAIL

 

 

8 To keep a log of your session

8.1 To start logging:

Logdump 71> LOG TO .txt

 

8.2 To write text to the log:

Logdump 72> WRITELOG “”

 

8.3 To stop logging:

Logdump 73> LOG STOP

 

9 To see the current Logdump environment

Logdump 74> ENV

This shows which features are enabled, such as filtering and header views, and it shows environment information such as the current trail and position.

 

10 To get online command help

Logdump 75> HELP

 

11 To exit Logdump

Logdump 100> EXIT

Or…

Logdump 100> QUIT

 

Notes

也可直接通过如下命令在操作系统层面查看队列文件内容

Strings –a xxx

阅读(1465) | 评论(0) | 转发(0) |

0

上一篇：为何 GoldenGate replicat 进程显示 running 而不应用任何记录？

下一篇：Goldengate常用命令

给主人留下些什么吧！~~

评论热议

请登录后评论。

登录 注册

关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6