修改目的端trail文件的最大大小
trail
修改
原創
大小
文件
最大
目的
本文为原创，转载请注明出处： 修改目的端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
熱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 週前
By DDD
R.E.P.O.如果您聽不到任何人，如何修復音頻
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解鎖Myrise中的所有內容
1 個月前
By 尊渡假赌尊渡假赌尊渡假赌
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
熱門話題
釘釘怎麼修改群組裡的個人名稱_釘釘修改群組個人名稱方法
Mar 29, 2024 pm 08:41 PM
1.首先打開釘釘。 2.打開群組聊，點選右上角的三個點。 3.找到我在本群的暱稱。 4.點選進入即可修改儲存。
出現0x80004005錯誤代碼怎麼辦 小編教你0x80004005錯誤代碼解決方法
Mar 21, 2024 pm 09:17 PM
在電腦中刪除或解壓縮資料夾，時有時會彈出提示對話框“錯誤0x80004005：未指定錯誤”，如果遇到這中情況應該怎麼解決呢？提示錯誤碼0x80004005的原因其實很多，但大部分因為病毒導致，我們可以重新註冊dll來解決問題，下面，小編給大夥講解0x80004005錯誤代碼處理經驗。有使用者在使用電腦時出現錯誤代碼0X80004005的提示，0x80004005錯誤主要是由於電腦沒有正確註冊某些動態連結庫文件，或電腦與Internet之間存在不允許的HTTPS連接防火牆所引起。那麼如何
夸克網盤的檔案怎麼轉移到百度網盤？
Mar 14, 2024 pm 02:07 PM
夸克網盤和百度網盤都是現在最常用的儲存文件的網盤軟體，如果想要將夸克網盤內的文件保存到百度網盤，要怎麼操作呢？本期小編整理了夸克網盤電腦端的檔案轉移到百度網盤的教學步驟，一起來看看是怎麼操作吧。 夸克網盤的檔案怎麼存到百度網盤？要將夸克網盤的文件轉移到百度網盤，首先需在夸克網盤下載所需文件，然後在百度網盤用戶端中選擇目標資料夾並開啟。接著，將夸克網盤中下載的檔案拖放到百度網盤用戶端開啟的資料夾中，或使用上傳功能將檔案新增至百度網盤。確保上傳完成後在百度網盤中查看檔案是否已成功轉移。這樣就
hiberfil.sys是什麼檔案？ hiberfil.sys可以刪除嗎？
Mar 15, 2024 am 09:49 AM
最近有很多網友問小編，hiberfil.sys是什麼文件？ hiberfil.sys佔用了大量的C碟空間可以刪除嗎？小編可以告訴大家hiberfil.sys檔是可以刪除的。下面就來看看詳細的內容。 hiberfil.sys是Windows系統中的隱藏文件，也是系統休眠文件。通常儲存在C盤根目錄下，其大小與系統安裝記憶體大小相當。這個檔案在電腦休眠時被使用，其中包含了當前系統的記憶體數據，以便在恢復時快速恢復到先前的狀態。由於其大小與記憶體容量相等，因此它可能會佔用較大的硬碟空間。 hiber
抖音藍V可以改名字嗎？企業抖音藍V號名稱修改步驟有哪些？
Mar 22, 2024 pm 12:51 PM
抖音藍V認證是企業或品牌在抖音平台上的官方認證，有助於提升品牌形象和可信度。隨著企業發展策略的調整或品牌形象的更新，企業可能希望更改抖音藍V認證的名字。那麼，抖音藍V可以改名字嗎？答案是可以的。本文將詳細介紹企業抖音藍V號名稱修改的步驟。一、抖音藍V可以改名字嗎？抖音藍V帳號是可以改名字的。根據抖音官方規定，企業藍V認證帳號在滿足一定條件後，可以申請修改帳號名稱。一般來說，企業需要提供相關的證明資料，如營業執照、組織機構代碼證等，以證明修改名稱的合法性和必要性。二、企業抖音藍V號名稱修改步驟有哪
Win10睡眠時間修改技巧大揭秘
Mar 08, 2024 pm 06:39 PM
Win10睡眠時間修改技巧大揭密作為目前廣泛使用的作業系統之一，Windows10擁有睡眠功能，幫助使用者在不使用電腦時節省電力並保護螢幕。然而，有時候預設的睡眠時間並不符合使用者的需求，因此了解如何修改Win10睡眠時間就顯得格外重要。本文將揭示Win10睡眠時間修改的技巧，讓您輕鬆自訂系統的睡眠設定。一、透過「設定」修改Win10睡眠時間首先，最簡單的修
![如何在VirtualBox中增加磁碟大小[指南]](https://img.php.cn/upload/article/000/887/227/171064142025068.jpg?x-oss-process=image/resize,m_fill,h_207,w_330)
如何在VirtualBox中增加磁碟大小[指南]
Mar 17, 2024 am 10:10 AM
我們經常遇到預定義磁碟大小沒有空間容納更多資料的情況？如果您在稍後階段需要更多的虛擬機器硬碟空間，則必須擴充虛擬硬碟和分割區。在這篇文章中，我們將看到如何在VirtualBox中增加磁碟大小。增加VirtualBox中的磁碟大小重要的是要注意，您可能希望在執行這些操作之前備份您的虛擬硬碟文件，因為總是有可能出錯。有備份總是一個好的做法。然而，該過程通常運作良好，請確保在繼續之前關閉您的機器。有兩種方法可以增加VirtualBox中的磁碟大小。使用圖形使用者介面擴充VirtualBox的磁碟大小使用CL
MySQL中.ibd檔的作用詳解及相關注意事項
Mar 15, 2024 am 08:00 AM
MySQL中.ibd檔案的作用詳解及相關注意事項MySQL是一種流行的關聯式資料庫管理系統，資料庫中的資料儲存在不同的檔案中。其中，.ibd檔案是InnoDB儲存引擎中的資料文件，用於儲存表格中的資料和索引。本文將對MySQL中.ibd檔案的作用進行詳細解析，並提供相關程式碼範例以幫助讀者更好地理解。一、.ibd檔的作用：儲存資料：.ibd檔是InnoDB存
