當(dāng)前位置：首頁(yè) > 编程资源 > 编程问答 >内容正文

编程问答

Oracle Golden Gate 系列十五 -- GG Trails 说明

發(fā)布時(shí)間：2025/7/14 编程问答 16 豆豆

生活随笔收集整理的這篇文章主要介紹了 Oracle Golden Gate 系列十五 -- GG Trails 说明小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.

一.Trails 說(shuō)明

理論知識(shí)在系列一里有說(shuō)明，這里在拿出來(lái)看一下：

Oracle Golden Gate 系列一 -- GG 架構(gòu) 說(shuō)明

http://blog.csdn.net/tianlesoftware/article/details/6925907

To support thecontinuous extraction and replication of database changes, Oracle GoldenGatestores the captured changes temporarily on disk in a series of files called a trail.A trail can exist on the source or target system, or on an intermediary system,depending on how you configure Oracle GoldenGate. On the local system it isknown as an extract trail (or local trail). On a remote system it is known as aremote trail.

--為了支持連續(xù)的extraction 和 replication 數(shù)據(jù)的改變，GG抓取這些改變的數(shù)據(jù)臨時(shí)存放在一系列的磁盤(pán)文件里，這些文件就叫trail。 Trail 文件可以放在Source或者Target system里，甚至可以放到轉(zhuǎn)換的系統(tǒng)上，這主要取決與GG 的配置，如果存放在local system上，就叫extract trail 或者 localtrail，如果存放在remote system上就叫作remote trail。

By using a trailfor storage, Oracle GoldenGate supports data accuracy and fault tolerance. Theuse of a trail also allows extraction and replication activities to occurindependently of each other. With these processes separated, you have morechoices for how data is delivered. For example, instead of extracting and replicatingchanges continuously, you could extract changes continuously but store them inthe trail for replication to the target later, whenever the target applicationneeds them.

???????通過(guò)使用trail，GG 支持精確的數(shù)據(jù)同步和故障處理。

1.1 Processes that write to, and read, a trail

The primaryExtract process writes to a trail. Only one Extract process can write to atrail.

?????? Extract 進(jìn)程可以將capture data 寫(xiě)入trail。只允許一個(gè)Extract進(jìn)程寫(xiě)入一個(gè)trail。

Processes that read the trail are:

以下2個(gè)進(jìn)程可以讀取trail 文件：

(1)????Data-pump Extract: Extractsdata from a local trail for further processing, if needed, and transfers it tothe target system or to the next Oracle GoldenGate process downstream in theOracle GoldenGate configuration.

(2)????Replicat: Reads a trail toapply change data to the target database.

Data pump 說(shuō)明，可以參考：

Oracle Golden Gate 系列九 --GG 數(shù)據(jù)初始化裝載說(shuō)明與示例

http://blog.csdn.net/tianlesoftware/article/details/6976551

1.2 Trail maintenance

Trail files arecreated as needed during processing, and they are aged automatically to allowprocessing to continue without interruption for file maintenance. By default,trails are stored in the dirdat sub-directory of the Oracle GoldenGatedirectory.

?????? --Trail 文件在進(jìn)程運(yùn)行時(shí)創(chuàng)建，trail 在使用時(shí)允許進(jìn)程在不中斷的情況下進(jìn)行維護(hù)。默認(rèn)情況下，trails存放在GG 安裝目錄的dirdat 子目錄下。

By default, eachfile in a trail is 10 MB in size. All file names in a trail begin with the sametwo characters, which you assign when you create the trail. As files arecreated, each name is appended with a unique, six-digit serial (sequence)number from 000000 through 999999, for example c:\ggs\dirdat\tr000001. When thetrail sequence number reaches 999999, the numbering starts over at 000000.

--默認(rèn)情況下，每個(gè)trails 文件為10MB，所有的trails由2個(gè)相同的字母開(kāi)頭，當(dāng)創(chuàng)建trail時(shí)，每個(gè)trail 文件名有我們指定的2個(gè)字母加6個(gè)數(shù)字組成，這樣來(lái)進(jìn)行唯一性約束。 6個(gè)數(shù)字從000000 到999999. 當(dāng)數(shù)字到達(dá)999999時(shí)，又繼續(xù)從000000開(kāi)始。

You can createmore than one trail to separate the data from different objects or applications.You link the objects that are specified in a TABLE or SEQUENCE parameter to a trailthat is specified with an EXTTRAIL or RMTTRAIL parameter in the Extractparameter file.

--可以創(chuàng)建多個(gè)trail 文件已分別存放不同對(duì)象的trail。

Aged trail filescan be purged by using the Manager parameter PURGEOLDEXTRACTS.

--使用中的trail 文件可以使用Manager 參數(shù)：PURGEOLDEXTRACTS進(jìn)行清空。

1.3 How processes write to a trail

To maximizethroughput, and to minimize I/O load on the system, extracted data is sent intoand out of a trail in large blocks. Transactional order is preserved. Bydefault, Oracle GoldenGate writes data to the trail in canonical format, aproprietary format which allows it to be exchanged rapidly and accurately amongheterogeneous databases. However, data can be written in other formats that arecompatible with different applications.

???????--為了最大的吞吐量和最小的系統(tǒng)I/O, trail 文件的寫(xiě)入和讀取都是按large block 進(jìn)行。默認(rèn)情況下，GG 寫(xiě)入trail 的文件的內(nèi)容都是特定的格式，特定的格式可以實(shí)現(xiàn)快速的exchange 和不同數(shù)據(jù)庫(kù)之間實(shí)現(xiàn)精確的同步。當(dāng)然也可以根據(jù)不同的應(yīng)用，按照不同的格式進(jìn)行寫(xiě)入。

??????

By default,Extract operates in append mode, where if there is a process failure, arecovery marker is written to the trail and Extract appends recovery data tothe file so that a history of all prior data is retained for recovery purposes.

???????默認(rèn)情況下，Extract是append 模式，如果一個(gè)process 失敗，在下次啟動(dòng)Extract 時(shí)，recovermarkder 可以寫(xiě)入這個(gè)trail，進(jìn)行Extract recovery操作，但是這個(gè)啟動(dòng)Extract的過(guò)程會(huì)比較長(zhǎng)。關(guān)于這個(gè)Extract recovery 的監(jiān)控，在以下鏈接的1.1 小結(jié)有說(shuō)明。

Oracle Golden Gate 系列十四 --監(jiān)控 GG 狀態(tài) 說(shuō)明

http://blog.csdn.net/tianlesoftware/article/details/6989454

In append mode,the Extract initialization determines the identity of the last complete transactionthat was written to the trail at startup time. With that information, Extract endsrecovery when the commit record for that transaction is encountered in the datasource; then it begins new data capture with the next committed transactionthat qualifies for extraction and begins appending the new data to the trail. Adata pump or Replicat starts reading again from that recovery point.

?????? --在append 模式下，在啟動(dòng)Extract 初始化時(shí)，會(huì)在trail中找到last completetransaction的位置。然后從這個(gè)位置開(kāi)始進(jìn)行recovery，直到在data source里遇到commitrecord，就結(jié)束Extract Recovery。Extract 正常啟動(dòng)。???? Extract 進(jìn)程正常啟動(dòng)之后，就可以正常的以append 方式寫(xiě)入新的capturedata。

?????? Data pump 進(jìn)程或者Replicat 進(jìn)程從Recover point 開(kāi)始讀取data。

?????? 這個(gè)last complete transaction 可以理解為recover point，因?yàn)镚G 也是根據(jù)歸檔和onlineredo 來(lái)的，所以這個(gè)recovery 過(guò)程也是從DB 的log里進(jìn)行判斷，找到了commit record，即GG和 DB 的log 一致，結(jié)束recovery 過(guò)程。

??????

?????? 這段recovery 出來(lái)的tail data 還沒(méi)有發(fā)送到target 上或者還沒(méi)有應(yīng)用，所以Data pump 或 replicat 進(jìn)程從這個(gè)recovery point 開(kāi)始恢復(fù)。

在恢復(fù)階段，我們查看Extract 進(jìn)程的狀態(tài)，就顯示為APPEND。

?????? 這一段ExtractRecovery 過(guò)程是根據(jù)自己的理解來(lái)寫(xiě)的，可能不完全正確，有其他理解的可以互相討論。

Overwrite modeis another version of Extract recovery that was used in versions of Oracle GoldenGateprior to version 10.0. In these versions, Extract overwrites the existing transactiondata in the trail after the last write-checkpoint position, instead ofappending the new data. The first transaction that is written is the first onethat qualifies for extraction after the last read checkpoint position in thedata source.

???????--Overwrite 模式的Extract Recovery 是GG 10.0版本之前使用的。 Extract 重寫(xiě)trail中已經(jīng)存在，并在lastwrite-checkpoint position之后的transaction data，代替了append new data。

If the versionof Oracle GoldenGate on the target is older than version 10, Extract will automaticallyrevert to overwrite mode to support backward compatibility. This behavior canbe controlled manually with the RECOVERYOPTIONS parameter.

--如果Target GG的版本小于10，ExtractGG的版本大于10，為了兼容性， Extract 將自動(dòng)轉(zhuǎn)換成overwrite 模式。可以通過(guò)RECOVERYOPTIONS參數(shù)手工的控制這種自動(dòng)轉(zhuǎn)換的功能。

1.4 Trail format

As of OracleGoldenGate version 10.0, each file of a trail contains a file header recordthat is stored at the beginning of the file. The file header containsinformation about the trail file itself. Previous versions of Oracle GoldenGatedo not contain this header.

在GG 10.0版本里，每個(gè)trailfile 包含一個(gè)file header，其用來(lái)存儲(chǔ)beginning of file。 10.0 版本之前的GG 不包含header。

Each data recordin a trail file also contains a header area, as well as a data area. The recordheader contains information about the transaction environment, and the dataarea contains the actual data values that were extracted.

每條trail file的record中包含一個(gè)headerarea和data area。 Record 的headerarea 包含transaction environment，data area 包含實(shí)際的的extracteddata。

Trail 的格式在第二部分具體進(jìn)行說(shuō)明。

二．Trails 中record format

?????? 我們可以通過(guò)GG 自帶的logdump 工具來(lái)查看trails 文件的具體格式。

2.1 logdump 工具使用說(shuō)明

MOS 上有關(guān)logdump的2篇文檔：

How To Save A Part Of A GoldenGate Trail ToA New Trail [ID 966188.1]

Oracle GoldenGate - Using the GoldenGateLogdump Utility to Manually Load Balance across Multiple Processes [ID1301300.1]

2.1.1 進(jìn)入GG 安裝目錄，運(yùn)行l(wèi)ogdump命令。

cgg1:/home/oracle> cd /u01/ggate/

gg1:/u01/ggate> logdump

Oracle GoldenGate Log File Dump Utility

Version 11.1.1.1OGGCORE_11.1.1_PLATFORMS_110421.2040

Logdump 1 >

2.1.2 set up the view –建立logdump環(huán)境

（1）To view the record header with thedata:

Logdump 1 >ghdr on

（2）To add column information

Logdump 2 >detail on

-- Column informationincludes the number and length in hex and ASCII.

（3）To add hex and ASCII data values to the column information:

Logdump 3 >detail data

（4）To view user tokens:

Logdump 4 >usertoken on

（5）To control how much record data is displayed:

Logdump 5> RECLEN <length>

Logdump 5 >reclen 1000

Reclen set to 1000

2.1.3 To open a trail file　打開(kāi)文件

（1）指定trail 文件

Logdump 6 >open /u01/ggate/dirdat/lt000008

Current LogTrail is/u01/ggate/dirdat/lt000008

（2）To go to the first record and thenmove through records in sequence:

Logdump 7>NEXT????or N

示例：

Logdump 7 >n

___________________________________________________________________

Hdr-Ind???:???? E? (x45)????Partition? :???? .?(x04)?

UndoFlag??:???? .? (x00)????BeforeAfter:???? A? (x41)?

RecLength?:??? 45? (x002d)??IO Time??? : 2011/11/1713:11:28.000.000??

IOType????:???? 5? (x05)????OrigNode?? :?? 255?(xff)

TransInd??:???? .? (x00)????FormatType :???? R? (x52)

SyskeyLen?:???? 0? (x00)????Incomplete :???? .? (x00)

AuditRBA??:???????? 23?????? AuditPos?? : 16783888

Continued?:???? N? (x00)????RecCount?? :???? 1?(x01)

2011/11/17 13:11:28.000.000 Insert?????????????? Len??? 45 RBA 1009

Name: DAVE.BL

After?Image:????????????????????????????????????????????Partition 4?? G? b??

?00000006 0000 0002 424c 0001 0006 0000 0002 3839 | ........BL........89?

?00020015 0000 3230 3131 2d31 312d 3137 3a31 333a | ......2011-11-17:13:?

?30393a32 34?????????????????????????????????????| 09:24?

Column????0 (x0000), Len???? 6 (x0006)?

?00000002 424c???????????????????????????????????| ....BL?

Column????1 (x0001), Len???? 6 (x0006)?

?00000002 3839???????????????????????????????????| ....89?

Column????2 (x0002), Len??? 21 (x0015)?

?00003230 3131 2d31 312d 3137 3a31 333a 3039 3a32 | ..2011-11-17:13:09:2?

?34???????????????????????????????????????????????| 4?

2.1.4 To go to a specific RBA in the file定位

（1）To go to an RBA anywhere in the file:

Logdump 9> POS <rba>

Logdump 10> N

示例：

GGSCI (gg1) 8> info ext1

EXTRACT???EXT1????? Last Started 2011-11-1910:02?? Status RUNNING

Checkpoint Lag?????? 11:49:46 (updated 00:00:06 ago)

Log Read Checkpoint? Oracle Redo Logs

???????????????????? 2011-11-18 22:12:21? Seqno 26, RBA 22834688

Logdump 10 >pos 22834688

Reading forward from RBA 22834688

Logdump 11 >n

--因?yàn)楫?dāng)前的extract使用的trail 文件不是lt000008，所以這里沒(méi)有顯示結(jié)果。

（2）To go to the first record in the file:

Logdump 11> POS FIRST

或

Logdump 11> POS 0

示例：

Logdump 12 >pos 0

Reading forward from RBA 0

Logdump 13 >n

2011/11/17 13:08:42.353.436 FileHeader?????????? Len??942 RBA 0

Name: *FileHeader*

?30000199 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1...?

?00023200 0004 2000 0000 3300 0008 02f1 d81a ab92 | ..2... ...3.........?

?1f1c3400 0014 0012 7572 693a 6767 313a 3a75 3031 | ..4.....uri:gg1::u01?

?3a676761 7465 3600 001c 001a 2f75 3031 2f67 6761 | :ggate6...../u01/gga?

?74652f64 6972 6461 742f 6c74 3030 3030 3038 3700 | te/dirdat/lt0000087.?

?00010138 0000 0400 0000 0839 0000 0800 0000 0000 | ...8.......9........?

?001b493a 0000 8107 3133 3633 3532 3200 0000 0000 | ..I:....1363522.....?

?00000000 0000 0000 0000 0000 0000 0000 0000 0000 | ....................?

2.1.5 To filter based on a table name

（1）To filter out everything exceptrecords containing a specific table name:

Logdump 14> FILTER INCLUDE/EXCLUDEFILENAME <schema>.<table>

Now, when you use the N command, you willonly see records that satisfy this filter.

（2）To remove the current filtercriteria

?Logdump14> FILTER CLEAR

（3）To filter on multiple conditions

?Logdump 14> FILTER INCLUDEFILENAME <schema>.<table>; FILTER RECTYPE <record_type>;FILTER MATCH ALL

2.1.6 To count the records in a trail file

Logdump 14> COUNT

示例：

Logdump 14 >count

LogTrail /u01/ggate/dirdat/lt000008 has 37records

Total Data Bytes????????????? 3834

? AvgBytes/Record???????????? 103

Insert????????????????????????? 34

RestartOK??????????????????????? 1

DDL????????????????????????????? 1

Others?????????????????????????? 1

After Images??????????????????? 36

Average of 4 Transactions

???Bytes/Trans .....?????? 1402

???Records/Trans ...????????? 9

???Files/Trans .....????????? 1

??????????????????????????????????????????????????Partition 0

Total Data Bytes????????????? 1153

? AvgBytes/Record???????????? 576

RestartOK??????????????????????? 1

DDL?????????????????????????????1

After Images???????????????????? 2

*FileHeader*??????????????????????????????????????Partition 0

Total Data Bytes?????????????? 942

? AvgBytes/Record???????????? 942

Others?????????????????????????? 1

DAVE.BL??????????????? ????????????????????????????Partition 4

Total Data Bytes????????????? 1739

? AvgBytes/Record????????????? 51

Insert????????????????????????? 34

After Images??????????????????? 34

2.1.7 To save records to a new trail file

（1）To save the whole file:

Logdump 15> SAVE <file>

Where: <file> is the name of the newfile.

（2）To save a subset of records:

Logdump15> SAVE <file> <n>RECORDS

To close the current file and open the nextone in the trail

Logdump 15> NEXTTRAIL

2.1.8 To keep a log of your session

（1） To start logging:

Logdump 15> LOG TO <filename>.txt

（2）To write text to the log:

Logdump 15> WRITELOG “<text>”

（3）To stop logging:

Logdump 15> LOG STOP

2.1.9 To see the current Logdumpenvironment

Logdump 15> ENV

This shows whichfeatures are enabled, such as filtering and header views, and it showsenvironment information such as the current trail and position.

示例：

Logdump 15 >env

Version???????????? : Linux, x64, 64bit (optimized) onApr 21 2011 22:44:06

Current Directory?? : /u01/ggate

LogTrail??????????? : /u01/ggate/dirdat/lt000008

Trail Format??????? : New

End of File???????? : 6985

Current Position??? : 0???Forward

Next Position?????? : 0

Last Modtime??????? : 2011/11/17 17:16:22.000.000

Display RecLen????? : 200

Logtrail Filter???? : On

Show Ghdr?????????? : On?

Detail????????????? : Data?

UserToken?????????? : On?

Trans History?????? : 0 Transactions, Records 100, Bytes100000

LargeBlock I/O????? : On, Blocksize 57344

Local System??????? : LittleEndian

Logtrail Data?????? : BigEndian/ASCII

Logtrail Headers??? : ASCII

Dump??????????????? : ASCII

Savefile comments?? : Off

Timeoffset????????? : LOCAL

Scan Notify Interval: 10000 records,Scrolling On?

2.1.10 To get online command help

Logdump 17> HELP

2.1.11 To exit Logdump

Logdump 17> EXIT

或

Logdump 17> QUIT

2.2 Trails 格式說(shuō)明

這個(gè)是官方文檔上的一個(gè)圖。我們現(xiàn)在來(lái)看一下，

2.2.1 Record header area

The OracleGoldenGate record header provides metadata of the data that is contained in therecord and includes the following information.

--GG record header 包含以下內(nèi)容：

(1)????The operation type, such as aninsert, update, or delete

(2)????The before or after indicatorfor updates

(3)????Transaction information, suchas the transaction group and commit timestamp

2.2.1.1 Description of header fields

The following describes the fields of the Oracle GoldenGate record header. Some fields applyonly to certain platforms.

2.2.1.2 Using header data

Some of the dataavailable in the Oracle GoldenGate record header can be used for mapping byusing the GGHEADER option of the @GETENV function or by using any of the followingtransaction elements as the source expression in a COLMAP statement in the TABLEor MAP parameter.

(1)????GGS_TRANS_TIMESTAMP

(2)????GGS_TRANS_RBA

(3)????GGS_OP_TYPE

(4)????GGS_BEFORE_AFTER_IND

2.2.2 Record data area

The data area of the Oracle GoldenGatetrail record contains the following:

Trail 的data area 記錄了如下內(nèi)容：

(1)????The time that the change waswritten to the Oracle GoldenGate file

(2)????The type of database operation

(3)????The length of the record

(4)????The relative byte addresswithin the trail file

(5)????The table name

(6)????The data changes in hex format

The followingexplains the differences in record image formats used by Oracle GoldenGate onWindows, UNIX, Linux, and NonStop systems. The terms “full” and “compressed”image format are used in the descriptions. These terms are used in a differentcontext here than when they are used in other parts of the documentation inreference to how Extract writes column data to the trail, meaning whether onlythe key and changed columns are written (“compressed”) versus whether allcolumns are written to the trail (“uncompressed” or “full image”).

2.2.2.1 Full record image format

Full record imageformat is only generated in the trail when the source system is HP NonStop, andonly when the IOType specified in the record header is one of the following:

--Full record image 格式僅在source system 是HPNonStop，并且在IOTye 指定如下類(lèi)型時(shí)生成：

3 — Delete

5 — Insert

10 — Update

Each full recordimage has the same format as if retrieved from a program reading the originalfile or table directly. For SQL tables, datetime fields, nulls, and other datais written exactly as a program would select it into an application buffer.Although datetime fields are represented internally as an eight-byte timestamp,their external form can be up to 26 bytes expressed as a string. Enscriberecords are retrieved as they exist in the original file.

When theoperation type is Insert or Update, the image contains the contents of therecord after the operation (the after image). When the operation type is Delete,the image contains the contents of the record before the operation (the beforeimage).

--如果是insert 或 update 操作，那么image包含的是after image，即修改之后的data，如果是delete，則保存的beforeimage。

For recordsgenerated from an Enscribe database, full record images are output unless the originalfile has the AUDITCOMPRESS attribute set to ON. When AUDITCOMPRESS is ON, compressedupdate records are generated whenever the original file receives an update operation.(A full image can be retrieved by the Extract process by using the FETCHCOMPS parameter.)

2.2.2.2 Compressed record format

By default,trail records written by processes on Windows and UNIX systems are always compressed.The format of a compressed record is as follows:

<columnindex><column length><column data>[...]

--默認(rèn)情況下，trail record是compress的，為什么要compress在下一節(jié)說(shuō)明。

Where:

(1)?????<column index> is the ordinal index ofthe column within the source table (2 bytes).

(2)????<column length> is thelength of the data (2 bytes).

(3)????<column data> is thedata, including NULL or VARCHAR length indicators.

Enscribe recordswritten from the NonStop platform may be compressed. The format of a compressedEnscribe record is as follows:

<fieldoffset><field length><field value>[...]

Where:

(1)?????<field offset> is the offset within theoriginal record of the changed value (2 bytes).

(2)????<field length> is thelength of the data (2 bytes).

(3)????<field data> is the data,including NULL or VARCHAR length indicators.

The first fieldin a compressed Enscribe record is the primary or system key.

2.2.2.3 Tokens area

The trail recordalso can contain two areas for tokens. One is for internal use and is not documentedhere, and the other is the user tokens area. User tokens are environment valuesthat are captured and stored in the trail record for replication to targetcolumns or other purposes. If used, these tokens follow the data portion of therecord and appear similar to the following when viewed with Logdump:

--trail record 的token 包含2個(gè)areas，其中一個(gè)供內(nèi)部使用，文檔就不做說(shuō)明，另一個(gè)是user token。

2.2.2.4 Oracle GoldenGate operation types

The followingare some of the Oracle GoldenGate operation types. Types may be added as newfunctionality is added to Oracle GoldenGate. For a more updated list, use the SHOWRECTYPE command in the Logdump utility.

2.2.3 Oracle GoldenGate trail header record

In addition tothe transaction-related records that are in the Oracle GoldenGate trail, each trailfile contains a file header.

--在每個(gè)trail file中除了之前講的trail header，trailarea，還有一個(gè)file header。

The file headeris stored as a record at the beginning of a trail file preceding the data records.The information that is stored in the trail header provides enough information aboutthe records to enable an Oracle GoldenGate process to determine whether the recordsare in a format that the current version of Oracle GoldenGate supports.

The trail headerfields are stored as tokens, where the token format remains the same across allversions of Oracle GoldenGate. If a version of Oracle GoldenGate does not supportany given token, that token is ignored. Depracated tokens are assigned a defaultvalue to preserve compatibility with previous versions of Oracle GoldenGate.

You can view thetrail header with the FILEHEADER command in the Logdump utility.

三.trail再壓縮

?????? 在上面一節(jié)看到，默認(rèn)情況下，trails 是compress的。當(dāng)數(shù)據(jù)進(jìn)行異地傳輸時(shí)，網(wǎng)絡(luò)負(fù)載是影響數(shù)據(jù)傳輸效率的關(guān)鍵因素。GoldenGate的其中一個(gè)優(yōu)勢(shì)是，它極大地壓縮了傳輸?shù)膖rail文件。

在默認(rèn)壓縮（redo=>trail）的基礎(chǔ)上，GoldenGate提供了再壓縮方案：在傳輸trail之前對(duì)其進(jìn)行進(jìn)一步的壓縮，然后在寫(xiě)入遠(yuǎn)端trail之前再進(jìn)行解壓。官方文檔中說(shuō)明這次再壓縮的壓縮比至少在4:1，實(shí)際中壓縮比率會(huì)更高，有網(wǎng)友測(cè)試達(dá)10:1。

???????這里注意GoldenGate的再壓縮過(guò)程，壓縮之后發(fā)送到Target 端后，在寫(xiě)入遠(yuǎn)端trail前又解壓了回來(lái)，所以單純比較兩端的trail文件大小沒(méi)有變化。但是在傳輸過(guò)程中確實(shí)是壓縮了。

?????? 這樣的設(shè)計(jì)，可以減少對(duì)Replicat進(jìn)程提取trail的影響，從而也避免了加重原本負(fù)載就相對(duì)較大的Replicat進(jìn)程。

?????? GoldenGate的再壓縮，是在負(fù)責(zé)向遠(yuǎn)端發(fā)送trail的Extract進(jìn)程中配置的，因此一般情況下都是配置在datapump中。配置很簡(jiǎn)單，在RMTHOST參數(shù)中加入COMPRESS子參數(shù)，如下：

GGSCI (gg1) 42> view params dpump

extract dpump

userid ggate@gg1, password ggate

rmthost gg2, mgrport7809,compress,compressthreshold 0

rmttrail /u01/ggate/dirdat/lt

passthru

table dave.pdba;

-- COMPRESS啟用再壓縮，COMPRESSTHRESHOLD表示對(duì)大于該值的trail記錄塊進(jìn)行壓縮，取值0到28000，默認(rèn)1000，設(shè)置為0表示全部進(jìn)行壓縮

?????? 啟用了壓縮后，會(huì)消耗額外的CPU，在同步事務(wù)量較大的情況下，需要考慮CPU負(fù)載。但實(shí)際上在大部分的GoldenGate應(yīng)用場(chǎng)景中，網(wǎng)絡(luò)負(fù)載都遠(yuǎn)遠(yuǎn)大于CPU負(fù)載，啟用trail再壓縮的可能性還是很大的。

-------------------------------------------------------------------------------------------------------

版權(quán)所有，文章允許轉(zhuǎn)載，但必須以鏈接方式注明源地址，否則追究法律責(zé)任!

Blog:???? http://blog.csdn.net/tianlesoftware

Weibo: http://weibo.com/tianlesoftware

Email: ??tianlesoftware@gmail.com

Skype: tianlesoftware

-------加群需要在備注說(shuō)明Oracle表空間和數(shù)據(jù)文件的關(guān)系，否則拒絕申請(qǐng)----

DBA1 群：62697716(滿);?? DBA2 群：62697977(滿)??DBA3 群：62697850(滿)??

DBA 超級(jí)群：63306533(滿);? DBA4 群：83829929(滿) DBA5群： 142216823(滿)?

DBA6 群：158654907(滿)?? DBA7 群：69087192(滿)??DBA8 群：172855474

DBA 超級(jí)群2：151508914? DBA9群：102954821???? 聊天群：40132017(滿)

轉(zhuǎn)載于:https://www.cnblogs.com/spring3mvc/archive/2011/11/19/2414504.html

總結(jié)

以上是生活随笔為你收集整理的Oracle Golden Gate 系列十五 -- GG Trails 说明的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。

上一篇： jQuery美化select下拉框
下一篇： Oracle Linux 6.1 说明