如果不設定PURGEOLDEXTRACTS引數trail file不會自動被刪除將佔用大量的空間,空間沾滿goldengate將hang，影響複製。PURGEOLDEXTRACTS引數可以被設定在Manager, Extract, and Replicat引數檔案中,oracle建議設定在Manager中。

以下僅介紹在Manager引數檔案中的設定

1 語法

Syntax PURGEOLDEXTRACTS

[, USECHECKPOINTS | NOUSECHECKPOINTS]

[, ]

2 解釋

Argument Description

The trail to purge. Use the fully qualified name.

USECHECKPOINTS Allows purging after all Extract and Replicat processes are done with

the data as indicated by checkpoints, according to any MINKEEP rules.

NOUSECHECKPOINTS Allows purging without considering checkpoints, based on keeping a

minimum of either:

◆ one file if no MINKEEP rule is used

or...

◆ the number of files specified with a MINKEEP rule.

Can be one of the following to set rules for the minimum amount of time

to keep data.

MINKEEPHOURS

Keeps an unmodified file for at least the specified number of hours.

MINKEEPDAYS

Keeps an unmodified file for at least the specified number of days.

MINKEEPFILES

Keeps at least unmodified trail files, including the active file.

Sets the frequency with which to purge old trail files. The default time

for Manager to process maintenance tasks is 10 minutes, as specified

with the CHECKMINUTES parameter (see page 137). Every 10 minutes,

Manager evaluates the PURGEOLDEXTRACTS frequency and conducts the

purge after the specified interval. can be one of the following:

FREQUENCYMINUTES

Sets the frequency, in minutes, with which to purge old trail files. The

default purge frequency is 60 minutes.

FREQUENCYHOURS

Sets the frequency, in hours, at which to purge old trail files.

frequency設定清楚old trail files.間隔時間預設值是CHECKMINUTES

3 控制規則

3.1 USECHECKPOINTS 規則

管理程式清楚這些被CHECKPOINTS表明已經被所有程式檢測過的檔案, 保證資料不丟失,USECHECKPOINTS是預設設定, NOUSECHECKPOINTS引數取消該檢測,生產環境建議設定USECHECKPOINTS

3.2 MINKEEP規則

該規則設定最小儲存時間或檔案數,

最小時間引數:MINKEEPHOURS, MINKEEPDAYS

最小檔案數引數:MINKEEPFILES

如果時間和檔案同時設定, MINKEEPHOURS, MINKEEPDAYS優先順序高於MINKEEPFILES, MINKEEPFILES將被忽略

3.3 兩種規則的組合使用

1 只有USECHECKPOINTS

如果CHECKPOINTS表明都被完成,只保留一個檔案

2 USECHECKPOINTS+MINKEEP

兩個功能同時生效

3 只有NOUSECHECKPOINTS

預設只保留一個檔案

4 NOUSECHECKPOINTS+MINKEEP

按照MINKEEP規則執行忽略CHECKPOINTS效驗

常用設定

PURGEOLDEXTRACTS /ggs/dirdat/AA*, USECHECKPOINTS, MINKEEPDAYS 2

4 示例

[oraogg@ylptnode1 ggate]$ ls -l /u01/ggate/dirdat/lt*

-rw-rw-rw- 1 oraogg oinstall 9999887 Oct 29 10:32 /u01/ggate/dirdat/lt000000

-rw-rw-rw- 1 oraogg oinstall 9999747 Oct 29 17:01 /u01/ggate/dirdat/lt000001

-rw-rw-rw- 1 oraogg oinstall 9999836 Oct 29 17:01 /u01/ggate/dirdat/lt000002

-rw-rw-rw- 1 oraogg oinstall 9999892 Oct 29 17:01 /u01/ggate/dirdat/lt000003

-rw-rw-rw- 1 oraogg oinstall 9999701 Oct 30 16:03 /u01/ggate/dirdat/lt000004

-rw-rw-rw- 1 oraogg oinstall 8810570 Oct 30 16:03 /u01/ggate/dirdat/lt000005

/u01/ggate/dirdat/lt:

total 0

[oraogg@ylptnode1 ggate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100

Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04

Source端

GGSCI (ylptnode1) 1> info all

Program Status Group Lag Time Since Chkpt

MANAGER STOPPED

EXTRACT RUNNING DPUMP 00:00:00 00:00:06

EXTRACT RUNNING EXT1 00:00:00 00:00:04

GGSCI (ylptnode1) 2> stop manager

Manager is already stopped.

GGSCI (ylptnode1) 3> info all

Program Status Group Lag Time Since Chkpt

MANAGER STOPPED

EXTRACT RUNNING DPUMP 00:00:00 00:00:07

EXTRACT RUNNING EXT1 00:00:00 00:00:05

GGSCI (ylptnode1) 4> edit params mgr

PORT 7809

PURGEOLDEXTRACTS /u01/ggate/dirdat/lt*, USECHECKPOINTS, MINKEEPHOURS 2

~

"dirprm/mgr.prm" 2L, 81C written

GGSCI (ylptnode1) 5>

GGSCI (ylptnode1) 5> start manager

Manager started.

GGSCI (ylptnode1) 6> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DPUMP 00:00:00 00:00:08

EXTRACT RUNNING EXT1 00:00:00 00:00:04

GGSCI (ylptnode1) 7> exit

[oraogg@ylptnode1 ggate]$ ls -l /u01/ggate/dirdat/lt*

-rw-rw-rw- 1 oraogg oinstall 8810570 Oct 30 16:03 /u01/ggate/dirdat/lt000005

[oraogg@ylptnode1 ggate]$ date

Thu Oct 31 16:30:07 CST 2013

Target端

[oraogg@ylptnode2 ggate]$ ls -l /u01/ggate/dirdat/lt*

-rw-rw-rw- 1 oraogg oinstall 9999921 Oct 29 10:32 /u01/ggate/dirdat/lt000000

-rw-rw-rw- 1 oraogg oinstall 9999781 Oct 29 17:01 /u01/ggate/dirdat/lt000001

-rw-rw-rw- 1 oraogg oinstall 9999870 Oct 29 17:01 /u01/ggate/dirdat/lt000002

-rw-rw-rw- 1 oraogg oinstall 9999926 Oct 29 17:01 /u01/ggate/dirdat/lt000003

-rw-rw-rw- 1 oraogg oinstall 9999735 Oct 30 16:03 /u01/ggate/dirdat/lt000004

-rw-rw-rw- 1 oraogg oinstall 8810604 Oct 30 16:03 /u01/ggate/dirdat/lt000005

/u01/ggate/dirdat/lt:

total 0

[oraogg@ylptnode2 ggate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100

Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04

GGSCI (ylptnode2) 1> STOP MANAGER

Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)? Y

Sending STOP request to MANAGER ...

Request processed.

Manager stopped.

GGSCI (ylptnode2) 2> edit params mgr

PORT 7809

PURGEOLDEXTRACTS /u01/ggate/dirdat/lt*, USECHECKPOINTS, MINKEEPHOURS 2

~

"dirprm/mgr.prm" 2L, 81C written

GGSCI (ylptnode2) 3> start manager

Manager started.

GGSCI (ylptnode2) 4> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REP1 00:00:00 00:00:08

GGSCI (ylptnode2) 5> exit

[oraogg@ylptnode2 ggate]$ ls -l /u01/ggate/dirdat/lt*

-rw-rw-rw- 1 oraogg oinstall 8810604 Oct 30 16:03 /u01/ggate/dirdat/lt000005

使用PURGEOLDEXTRACTS設定goldengate自動清除trail file

相關文章