GoldenGate学习笔记 Logdump队列文件分析

一　队列文件格式

1 Each change record written by GoldenGate to a trail or extract file includes a header area (Unless the NOHEADERS parameter was specified), a data area, and possibly a user token area.(一般由三部分组成)

具体字段的含义参考<>P 712

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

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10248702/viewspace-624580/ ，如需转载，请注明出处，否则将追究法律责任。

上一篇： GoldenGate学习笔记(7)_DDL支持安装与测试

下一篇： GoldenGate学习笔记(9)_常见问题

请登录后发表评论登录

全部评论

gdutllf2006

注册时间：2009-07-08

博文量
133
访问量

425847

ITPub博客

GoldenGate学习笔记(8)_Logdump队列文件结构分析

最新文章