修改目的端trail文件的最大大小

来源：动视网责编：小采时间：2020-11-09 14:58:39

修改目的端trail文件的最大大小

修改目的端trail文件的最大大小:本文为原创，转载请注明出处：修改目的端trail文件的最大大本文为原创，转载请注明出处：修改目的端trail文件的最大大小。本文产生的背景：在OGG源数据库上，检查文件系统使用率的过程中，发现$OGG_HOME的使用率相当高，于是追查原因，查到dirda

推荐度：

点击下载本文 文档为doc格式

导读修改目的端trail文件的最大大小:本文为原创，转载请注明出处：修改目的端trail文件的最大大本文为原创，转载请注明出处：修改目的端trail文件的最大大小。本文产生的背景：在OGG源数据库上，检查文件系统使用率的过程中，发现$OGG_HOME的使用率相当高，于是追查原因，查到dirda

本文为原创，转载请注明出处：修改目的端trail文件的最大大

本文为原创，转载请注明出处：

修改目的端trail文件的最大大小。

本文产生的背景：

在OGG源数据库上，检查文件系统使用率的过程中，发现$OGG_HOME的使用率相当高，于是追查原因，查到dirdat目录下有大量的trail文件没有删除。这些trail文件都是去年产生的，早就被传输到目的端了。但是为什么没有被mgr 的PURGEOLDEXTRACTS 参数正常删除呢？

后来检查发现：源头的trail file（/u02/ggs/dirdat/aa）和目的端的trail file（u02/ggs/dirrdat/aa）的名字一样，这是导致源头os上 trail文件没有删除的原因。

具体是这么回事：比如说源头trail file（/u02/ggs/dirdat/aa）到了aa001000，此时目的端的trail file（u02/ggs/dirrdat/aa）却只到了aa000010。

OGG的mgr进程删除trail文件的判断逻辑为：

检查整个复制环境（包括源头和目的端）中的相同trail文件名的trail，获得最小的那个trail文件号，在此号之前的那些trail文件就会被OGG的mgr进程的PURGEOLDEXTRACTS 参数正常删除掉。

这里有人会问：为啥源头到了/u02/ggs/dirdat/aa001000，目的端却只到了/u02/ggs/dirdat/aa000010 ？这是不是意味着丢了数据？
这个很好解释，包括但是不限于如下的原因：
1.源头trail文件最大大小是20M一个，目的端trail文件的最大大小是2M一个。
2.源头trail文件中包括10个表的信息，目的端trail文件中包括2个表的信息（即：传输进程的参数文件起到了过滤需要同步的table的作用）

因此，如上的情况不代表传丢了数据。

本文的思路就是调整目的端trail文件的大小，让目的端trail文件号的生成速度加快，即：让目的端的trail文件号尽快的追上源头的trail文件号，从而让OGG的mgr进程尽快的删除源头的trail文件。

额外注意：
1.调整目的端trail文件的大小是在源头进行的，具体来说就是：修改源头的传输进程
2.在整个过程中，只需要停止一下传输进程，然后修改rmttrail文件大小，然后再启动传输进程即可。可以说风险极其微小。

调整步骤（以下均在源头机器上进行）

1.info 传输进程, showch
2.info 传输进程, detail
3.stop 传输进程
4.alter rmttrail /u02/ggs/dirdat/aa, extract 传输进程, megabytes 1
--->这个alter命令是修改远程的trail file /u02/ggs/dirdat/aa 的最大大小为1MB
5.info 传输进程, showch
6.info 传输进程, detail
7.start 传输进程

如下是当时操作的记录：

GGSCI (hosta) 2> info dpaa, showch

EXTRACT DPAA Last Started 2014-07-25 17:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /u02/ggs/dirdat/aa019357
 2014-08-01 14:08:29.000000 RBA 44906368

Current Checkpoint Detail:

Read Checkpoint #1

 GGS Log Trail

 Startup Checkpoint (starting position in the data source):
 Sequence #: 18965
 RBA: 36113095
 Timestamp: 2014-07-25 16:37:28.000000
 Extract Trail: /u02/ggs/dirdat/aa

 Current Checkpoint (position of last record read in the data source):
 Sequence #: 19357
 RBA: 44906368
 Timestamp: 2014-08-01 14:08:29.000000
 Extract Trail: /u02/ggs/dirdat/aa

Write Checkpoint #1

 GGS Log Trail

 Current Checkpoint (current write position):
 Sequence #: 5341
 RBA: 36395386
 Timestamp: 2014-08-01 14:08:35.734473
 Extract Trail: /u02/ggs/dirdat/aa

Header:
 Version = 2
 Record Source = A
 Type = 1
 # Input Checkpoints = 1
 # Output Checkpoints = 1


File Information:
 Block Size = 2048
 Max Blocks = 100
 Record Length = 2048
 Current Offset = 0


Configuration:
 Data Source = 0
 Transaction Integrity = 1
 Task Type = 0


Status:
 Start Time = 2014-07-25 17:30:55
 Last Update Time = 2014-08-01 14:08:35
 Stop Status = A
 Last Result = 400

GGSCI (hosta) 3> info DPAA, showch

EXTRACT DPAA Last Started 2014-07-25 17:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /u02/ggs/dirdat/aa019357
 2014-08-01 14:09:43.000000 RBA 46549780

Current Checkpoint Detail:

Read Checkpoint #1

 GGS Log Trail


 Startup Checkpoint (starting position in the data source):
 Sequence #: 18965
 RBA: 36113095
 Timestamp: 2014-07-25 16:37:28.000000
 Extract Trail: /u02/ggs/dirdat/aa

 Current Checkpoint (position of last record read in the data source):
 Sequence #: 19357
 RBA: 46549780
 Timestamp: 2014-08-01 14:09:43.000000
 Extract Trail: /u02/ggs/dirdat/aa

Write Checkpoint #1

 GGS Log Trail

 Current Checkpoint (current write position):
 Sequence #: 5341
 RBA: 36782463
 Timestamp: 2014-08-01 14:10:02.300738
 Extract Trail: /u02/ggs/dirdat/aa

Header:
 Version = 2
 Record Source = A
 Type = 1
 # Input Checkpoints = 1
 # Output Checkpoints = 1


File Information:
 Block Size = 2048
 Max Blocks = 100
 Record Length = 2048
 Current Offset = 0


Configuration:
 Data Source = 0
 Transaction Integrity = 1
 Task Type = 0


Status:
 Start Time = 2014-07-25 17:30:55
 Last Update Time = 2014-08-01 14:10:02
 Stop Status = A
 Last Result = 400


GGSCI (hosta) 4> info dpaa, detail


EXTRACT DPAA Last Started 2014-07-25 17:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File /u02/ggs/dirdat/aa019357
 2014-08-01 14:10:00.000000 RBA 46852715


 Target Extract Trails:


 Remote Trail Name Seqno RBA Max MB


 /u02/ggs/dirdat/aa 5341 36852196 50 --->注意此处的50M，此时是改之前。


 Extract Source Begin End 


 /u02/ggs/dirdat/aa019357 2014-07-25 16:37 2014-08-01 14:10
 /u02/ggs/dirdat/aa018965 2014-07-25 16:14 2014-07-25 16:37
 /u02/ggs/dirdat/aa018965 2014-07-25 12:20 2014-07-25 16:14
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-04 18:17 2014-07-25 12:20
 /u02/ggs/dirdat/aa017864 2014-06-30 18:32 2014-07-04 18:17
 /u02/ggs/dirdat/aa017531 2014-06-06 10:01 2014-06-30 18:32
 /u02/ggs/dirdat/aa016295 2014-06-06 10:01 2014-06-06 10:01
 /u02/ggs/dirdat/aa016295 2014-06-06 10:01 2014-06-06 10:01
 /u02/ggs/dirdat/aa016295 2014-06-01 08:39 2014-06-06 10:01
 /u02/ggs/dirdat/aa016049 2014-05-02 10:06 2014-06-01 08:39
 /u02/ggs/dirdat/aa014617 2014-04-11 02:49 2014-05-02 10:06
 /u02/ggs/dirdat/aa013640 2014-03-29 09:01 2014-04-11 02:49
 /u02/ggs/dirdat/aa013090 2014-03-18 22:12 2014-03-29 09:01
 /u02/ggs/dirdat/aa012599 2014-01-20 20:22 2014-03-18 22:12
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-03 18:59 2014-01-20 20:22
 /u02/ggs/dirdat/aa009782 2013-12-02 10:21 2014-01-03 18:59
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-10-26 07:26 2013-12-02 10:21
 /u02/ggs/dirdat/aa006549 2013-10-11 16:13 2013-10-26 07:26
 /u02/ggs/dirdat/aa005885 2013-08-18 17:36 2013-10-11 16:13
 /u02/ggs/dirdat/aa003826 2013-08-17 16:22 2013-08-18 17:36
 /u02/ggs/dirdat/aa003803 2013-06-28 17:53 2013-08-17 16:22
 /u02/ggs/dirdat/aa002302 2013-06-21 14:23 2013-06-28 17:53
 /u02/ggs/dirdat/aa002056 2013-06-17 21:51 2013-06-21 14:23
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51

Current directory /u02/ggs

Report file /u02/ggs/dirrpt/DPAA.rpt
Parameter file /u02/ggs/dirprm/dpaa.prm
Checkpoint file /u02/ggs/dirchk/DPAA.cpe
Process file /u02/ggs/dirpcs/DPAA.pce
Stdout file /u02/ggs/dirout/DPAA.out
Error log /u02/ggs/ggserr.log


GGSCI (hosta) 5> stop dpaa

Sending STOP request to EXTRACT DPAA ...
Request processed.

GGSCI (hosta) 6> alter rmttrail /u02/ggs/dirdat/aa, extract dpaa, megabytes 1
RMTTRAIL altered.

GGSCI (hosta) 7> info dpaa, detail


EXTRACT DPAA Initialized 2014-07-25 17:30 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:11 ago)
Log Read Checkpoint File /u02/ggs/dirdat/aa019358
 2014-08-01 14:12:34.000000 RBA 1397741


 Target Extract Trails:

 Remote Trail Name Seqno RBA Max MB

 /u02/ggs/dirdat/aa 5341 38129829 1 --->注意此处的1M，此时是改之后。

 Extract Source Begin End 

 /u02/ggs/dirdat/aa019358 * Initialized * 2014-08-01 14:12
 /u02/ggs/dirdat/aa018965 2014-07-25 16:14 2014-07-25 16:37
 /u02/ggs/dirdat/aa018965 2014-07-25 12:20 2014-07-25 16:14
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-25 12:20 2014-07-25 12:20
 /u02/ggs/dirdat/aa018960 2014-07-04 18:17 2014-07-25 12:20
 /u02/ggs/dirdat/aa017864 2014-06-30 18:32 2014-07-04 18:17
 /u02/ggs/dirdat/aa017531 2014-06-06 10:01 2014-06-30 18:32
 /u02/ggs/dirdat/aa016295 2014-06-06 10:01 2014-06-06 10:01
 /u02/ggs/dirdat/aa016295 2014-06-06 10:01 2014-06-06 10:01
 /u02/ggs/dirdat/aa016295 2014-06-01 08:39 2014-06-06 10:01
 /u02/ggs/dirdat/aa016049 2014-05-02 10:06 2014-06-01 08:39
 /u02/ggs/dirdat/aa014617 2014-04-11 02:49 2014-05-02 10:06
 /u02/ggs/dirdat/aa013640 2014-03-29 09:01 2014-04-11 02:49
 /u02/ggs/dirdat/aa013090 2014-03-18 22:12 2014-03-29 09:01
 /u02/ggs/dirdat/aa012599 2014-01-20 20:22 2014-03-18 22:12
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-20 20:22 2014-01-20 20:22
 /u02/ggs/dirdat/aa010415 2014-01-03 18:59 2014-01-20 20:22
 /u02/ggs/dirdat/aa009782 2013-12-02 10:21 2014-01-03 18:59
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-12-02 10:21 2013-12-02 10:21
 /u02/ggs/dirdat/aa008290 2013-10-26 07:26 2013-12-02 10:21
 /u02/ggs/dirdat/aa006549 2013-10-11 16:13 2013-10-26 07:26
 /u02/ggs/dirdat/aa005885 2013-08-18 17:36 2013-10-11 16:13
 /u02/ggs/dirdat/aa003826 2013-08-17 16:22 2013-08-18 17:36
 /u02/ggs/dirdat/aa003803 2013-06-28 17:53 2013-08-17 16:22
 /u02/ggs/dirdat/aa002302 2013-06-21 14:23 2013-06-28 17:53
 /u02/ggs/dirdat/aa002056 2013-06-17 21:51 2013-06-21 14:23
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51
 /u02/ggs/dirdat/aa001918 2013-06-17 21:51 2013-06-17 21:51

Current directory /u02/ggs

Report file /u02/ggs/dirrpt/DPAA.rpt
Parameter file /u02/ggs/dirprm/dpaa.prm
Checkpoint file /u02/ggs/dirchk/DPAA.cpe
Process file /u02/ggs/dirpcs/DPAA.pce
Stdout file /u02/ggs/dirout/DPAA.out
Error log /u02/ggs/ggserr.log

GGSCI (hosta) 8> info dpaa,showch


EXTRACT DPAA Initialized 2014-07-25 17:30 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:24 ago)
Log Read Checkpoint File /u02/ggs/dirdat/aa019358
 2014-08-01 14:12:34.000000 RBA 1397741

Current Checkpoint Detail:

Read Checkpoint #1

 GGS Log Trail


 Startup Checkpoint (starting position in the data source):
 Sequence #: 18965
 RBA: 36113095
 Timestamp: 2014-07-25 16:37:28.000000
 Extract Trail: /u02/ggs/dirdat/aa

 Current Checkpoint (position of last record read in the data source):
 Sequence #: 19358
 RBA: 1397741
 Timestamp: 2014-08-01 14:12:34.000000
 Extract Trail: /u02/ggs/dirdat/aa

Write Checkpoint #1

 GGS Log Trail

 Current Checkpoint (current write position):
 Sequence #: 5341
 RBA: 38129829
 Timestamp: 2014-08-01 14:12:51.485592
 Extract Trail: /u02/ggs/dirdat/aa

Header:
 Version = 2
 Record Source = U
 Type = 1
 # Input Checkpoints = 1
 # Output Checkpoints = 1

File Information:
 Block Size = 2048
 Max Blocks = 100
 Record Length = 2048
 Current Offset = 0

Configuration:
 Data Source = 0
 Transaction Integrity = 1
 Task Type = 0

Status:
 Start Time = 2014-07-25 17:30:55
 Last Update Time = 2014-08-01 14:12:45
 Stop Status = G
 Last Result = 400

GGSCI (hosta) 9> start dpaa

Sending START request to MANAGER ...
EXTRACT DPAA starting

GGSCI (hosta) 10> exit

之后，在目的端上，trail文件生成如下：

[oracle@hostb dirdat]$ ls -lrt
total 95832
-rw-rw-rw- 1 oracle oinstall 49999851 Aug 1 12:41 aa005340
-rw-rw-rw- 1 oracle oinstall 38129829 Aug 1 14:16 aa005341
-rw-rw-rw- 1 oracle oinstall 999951 Aug 1 14:16 aa005342
-rw-rw-rw- 1 oracle oinstall 999046 Aug 1 14:18 aa005343
-rw-rw-rw- 1 oracle oinstall 998338 Aug 1 14:19 aa005344
-rw-rw-rw- 1 oracle oinstall 999930 Aug 1 14:20 aa005345
-rw-rw-rw- 1 oracle oinstall 998526 Aug 1 14:22 aa005346
-rw-rw-rw- 1 oracle oinstall 999772 Aug 1 14:23 aa005347

之后，在源头上，tail -f MGR.rpt
2014-08-01 14:20:51 INFO OGG-00957 Purged old extract file /u02/ggs/dirdat/aa005341, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 5347 > 5341.
2014-08-01 14:20:51 INFO OGG-00957 Purged old extract file /u02/ggs/dirdat/aa005342, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 5347 > 5342.
2014-08-01 14:20:51 INFO OGG-00957 Purged old extract file /u02/ggs/dirdat/aa005343, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 5347 > 5343.
2014-08-01 14:20:51 INFO OGG-00957 Purged old extract file /u02/ggs/dirdat/aa005344, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 5347 > 5344.
2014-08-01 14:20:51 INFO OGG-00957 Purged old extract file /u02/ggs/dirdat/aa005345, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 5347 > 5345.
2014-08-01 14:20:51 INFO OGG-00957 Purged old extract file /u02/ggs/dirdat/aa005346, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 5347 > 5346.

也许有人有疑问：在目的端上aa005346文件的最后写入时间是Aug 1 14:22，而看MGR.rpt,
2014-08-01 14:20:51 INFO OGG-00957 Purged old extract file /u02/ggs/dirdat/aa005346
这是因为，目的端的os时间比北京时间快而已。

修改目的端trail文件的最大大小

推荐度：

点击下载本文 文档为doc格式

标签：文件修改大小

热门焦点

修改目的端trail文件的最大大小

修改目的端trail文件的最大大小

修改目的端trail文件的最大大小

最新推荐

猜你喜欢

热门推荐