本文为原创，转载请注明出处： 修改目的端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时间比北京时间快而已。
声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
MySQL索引基数如何影响查询性能？Apr 14, 2025 am 12:18 AMMySQL索引基数对查询性能有显着影响：1.高基数索引能更有效地缩小数据范围，提高查询效率；2.低基数索引可能导致全表扫描，降低查询性能；3.在联合索引中，应将高基数列放在前面以优化查询。
MySQL：新用户的资源和教程Apr 14, 2025 am 12:16 AMMySQL学习路径包括基础知识、核心概念、使用示例和优化技巧。1)了解表、行、列、SQL查询等基础概念。2)学习MySQL的定义、工作原理和优势。3)掌握基本CRUD操作和高级用法，如索引和存储过程。4)熟悉常见错误调试和性能优化建议，如合理使用索引和优化查询。通过这些步骤，你将全面掌握MySQL的使用和优化。
现实世界Mysql：示例和用例Apr 14, 2025 am 12:15 AMMySQL在现实世界的应用包括基础数据库设计和复杂查询优化。1)基本用法：用于存储和管理用户数据，如插入、查询、更新和删除用户信息。2)高级用法：处理复杂业务逻辑，如电子商务平台的订单和库存管理。3)性能优化：通过合理使用索引、分区表和查询缓存来提升性能。
MySQL中的SQL命令：实践示例Apr 14, 2025 am 12:09 AMMySQL中的SQL命令可以分为DDL、DML、DQL、DCL等类别，用于创建、修改、删除数据库和表，插入、更新、删除数据，以及执行复杂的查询操作。1.基本用法包括CREATETABLE创建表、INSERTINTO插入数据和SELECT查询数据。2.高级用法涉及JOIN进行表联接、子查询和GROUPBY进行数据聚合。3.常见错误如语法错误、数据类型不匹配和权限问题可以通过语法检查、数据类型转换和权限管理来调试。4.性能优化建议包括使用索引、避免全表扫描、优化JOIN操作和使用事务来保证数据一致性
InnoDB如何处理酸合规性？Apr 14, 2025 am 12:03 AMInnoDB通过undolog实现原子性，通过锁机制和MVCC实现一致性和隔离性，通过redolog实现持久性。1）原子性：使用undolog记录原始数据，确保事务可回滚。2）一致性：通过行级锁和MVCC确保数据一致。3）隔离性：支持多种隔离级别，默认使用REPEATABLEREAD。4）持久性：使用redolog记录修改，确保数据持久保存。
MySQL的位置：数据库和编程Apr 13, 2025 am 12:18 AMMySQL在数据库和编程中的地位非常重要，它是一个开源的关系型数据库管理系统，广泛应用于各种应用场景。1）MySQL提供高效的数据存储、组织和检索功能，支持Web、移动和企业级系统。2）它使用客户端-服务器架构，支持多种存储引擎和索引优化。3）基本用法包括创建表和插入数据，高级用法涉及多表JOIN和复杂查询。4）常见问题如SQL语法错误和性能问题可以通过EXPLAIN命令和慢查询日志调试。5）性能优化方法包括合理使用索引、优化查询和使用缓存，最佳实践包括使用事务和PreparedStatemen
MySQL：从小型企业到大型企业Apr 13, 2025 am 12:17 AMMySQL适合小型和大型企业。1)小型企业可使用MySQL进行基本数据管理，如存储客户信息。2)大型企业可利用MySQL处理海量数据和复杂业务逻辑，优化查询性能和事务处理。
幻影是什么读取的，InnoDB如何阻止它们（下一个键锁定）？Apr 13, 2025 am 12:16 AMInnoDB通过Next-KeyLocking机制有效防止幻读。1）Next-KeyLocking结合行锁和间隙锁，锁定记录及其间隙，防止新记录插入。2）在实际应用中，通过优化查询和调整隔离级别，可以减少锁竞争，提高并发性能。
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
R.E.P.O.能量晶体解释及其做什么（黄色晶体）
3 周前By尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳图形设置
3 周前By尊渡假赌尊渡假赌尊渡假赌
刺客信条阴影：贝壳谜语解决方案
2 周前ByDDD
R.E.P.O.如果您听不到任何人，如何修复音频
3 周前By尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解锁Myrise中的所有内容
1 个月前By尊渡假赌尊渡假赌尊渡假赌
热工具
Dreamweaver Mac版
视觉化网页开发工具
安全考试浏览器
Safe Exam Browser是一个安全的浏览器环境，用于安全地进行在线考试。该软件将任何计算机变成一个安全的工作站。它控制对任何实用工具的访问，并防止学生使用未经授权的资源。
WebStorm Mac版
好用的JavaScript开发工具
mPDF
mPDF是一个PHP库，可以从UTF-8编码的HTML生成PDF文件。原作者Ian Back编写mPDF以从他的网站上“即时”输出PDF文件，并处理不同的语言。与原始脚本如HTML2FPDF相比，它的速度较慢，并且在使用Unicode字体时生成的文件较大，但支持CSS样式等，并进行了大量增强。支持几乎所有语言，包括RTL（阿拉伯语和希伯来语）和CJK（中日韩）。支持嵌套的块级元素（如P、DIV），
DVWA
Damn Vulnerable Web App (DVWA) 是一个PHP/MySQL的Web应用程序，非常容易受到攻击。它的主要目标是成为安全专业人员在合法环境中测试自己的技能和工具的辅助工具，帮助Web开发人员更好地理解保护Web应用程序的过程，并帮助教师/学生在课堂环境中教授/学习Web应用程序安全。DVWA的目标是通过简单直接的界面练习一些最常见的Web漏洞，难度各不相同。请注意，该软件中
