Home > Database > Mysql Tutorial > body text

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

WBOY
Release: 2016-06-07 15:59:20
Original
1309 people have browsed it

本文为原创,转载请注明出处: 修改目的端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
Copy after login

之后,在目的端上,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时间比北京时间快而已。
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template