Oracle GoldenGate 11g官方文檔Administrator’s Guide續一

CHAPTER 1

Introduction to Oracle GoldenGate

第一章

Oracle GoldenGate簡介

Oracle GoldenGate supported processing methods and databases

Oracle GoldenGate支持的處理方法和數據庫

Oracle GoldenGate enables the exchange and manipulation of data at the transaction level

among multiple, heterogeneous platforms across the enterprise 1 . Its modular architecture

gives you the flexibility to extract and replicate selected data records, transactional

changes, and changes to DDL (data definition language 2 ) across a variety of topologies.

With this flexibility, and the filtering, transformation, and custom processing features of

Oracle GoldenGate, you can support numerous business requirements:

Oracle GoldenGate支持在事務級別交換和處理數據

跨企業的多個異構平臺。其模塊化架構使您可以靈活地提取和復制事務性所選數據記錄

在多種拓撲之間進行更改以及對DDL（數據定義語言2）的更改。具有這種靈活性以及DDL（數據定義語言2）的過濾，轉換和自定義處理功能

使用Oracle GoldenGate，您可以支持眾多業務需求：

● Business continuance and high availability.

● 業務連續性和高可用

● Initial load and database migration.

● 初始化加載和數據遷移

● Data integration.

● 數據集成

● Decision support and data warehousing.

● 決策支持和數據倉庫

Figure 1 Oracle GoldenGate supported topologies

圖1 Oracle GoldenGate支持的拓撲

1. Support for replication across different database types and topologies varies by database type. See the Oracle GoldenGate Installation and Setup Guide for your database for detailed information about supported configurations.

   對不同數據庫類型和拓撲之間的復制的支持因數據庫類型而異。有關支持的配置的詳細信息，請參見數據庫的《 Oracle GoldenGate安裝和設置指南》
   

    2. DDL is not supported for all databases

        并非所有數據庫都支持DDL

For full information about processing methodology, supported topologies and functionality, and configuration requirements, see

the Oracle GoldenGate Installation and Setup Guide for your database.

有關處理方法，支持的拓撲和功能以及配置要求的完整信息，請參見

適用于您的數據庫的《 Oracle GoldenGate安裝和設置指南》。

Supported only as a target database. Cannot be a source database for Oracle GoldenGate extraction.

** Uses a capture module that communicates with the Oracle GoldenGate API to send change data to Oracle GoldenGate.

*** Only like-to-like configuration is supported. Data manipulation, filtering, column mapping not supported.

僅支持作為目標數據庫。不能是Oracle GoldenGate提取的源數據庫。

**使用與Oracle GoldenGate API通信的捕獲模塊將更改數據發送到Oracle GoldenGate。

***僅支持類似的配置。不支持數據操作，過濾，列映射。

Overview of the Oracle GoldenGate architecture

Oracle GoldenGate 體系結構概述

             可以出于以下目的配置Oracle GoldenGate

              ● 從一個數據庫中靜態提取數據記錄并加載這些記錄到另一個數據庫

              ●連續提取和復制事務DML操作和DDL更改（對于受支持的數據庫）以保持源數據和目標數據的一致性。

              ●從數據庫中提取并復制到數據庫外部的文件

            Oracle GoldenGate由以下組件組成：

            ●Extract

            ● Data pump

            ● Replicat

            ● Trails or extract files

            ● Checkpoints

            ● Manager

            ● Collector

Figure 2 illustrates the logical architecture of Oracle GoldenGate for initial data loads and

for the synchronization of DML and DDL operations. This is the basic configuration.

Variations of this model are recommended depending on business needs.

圖2 演示了Oracle GoldenGate用于初始數據加載以及DML和DDL操作同步的邏輯體系結構。這是基本配置。建議根據業務需要更改此模型。

Figure 2 Oracle GoldenGate logical architecture

圖二      Oracle GoldenGate邏輯架構

Overview of Extract

The Extract process runs on the source system and is the extraction (capture) mechanism

of Oracle GoldenGate. You can configure Extract in one of the following ways:

● Initial loads: For initial data loads, Extract extracts (captures) a current, static set of

data directly from their source objects.

● Change synchronization: To keep source data synchronized with another set of data,

Extract captures DML and DDL operations after the initial synchronization has taken

place.

Extract captures from a data source that can be one of the following:

● Source tables, if the run is an initial load.

● The database recovery logs or transaction logs (such as the Oracle redo logs or SQL/MX

audit trails). The actual method of capturing from the logs varies depending on the

database type.

● A third-party capture module. This method provides a communication layer that

passes data and metadata from an external API to the Extract API. The database

vendor or a third-party vendor provides the components that extract the data

operations and pass them to Extract.

When configured for change synchronization, Extract captures the DML and DDL

operations that are performed on objects in the Extract configuration. Extract stores these

operations until it receives commit records or rollbacks for the transactions that contain 

them. When a rollback is received, Extract discards the operations for that transaction.

When a commit is received, Extract persists the transaction to disk in a series of files called

a trail, where it is queued for propagation to the target system. All of the operations in each

transaction are written to the trail as a sequentially organized transaction unit. This

design ensures both speed and data integrity.

NOTE Extract ignores operations on objects that are not in the Extract configuration, even

though the same transaction may also include operations on objects that are in the

Extract configuration.

Multiple Extract processes can operate on different objects at the same time. For example,

two Extract processes can extract and transmit in parallel to two Replicat processes (with

two persistence trails) to minimize target latency when the databases are large. To

differentiate among different Extract processes, you assign each one a group name (see

“Overview of groups” on page 16).

Extract概述

抽取進程在源系統上運行，是Oracle GoldenGate的抽?。ú东@）機制?？梢酝ㄟ^以下方式之一配置提?。?/span>

● 初始加載：對于初始數據加載，直接從源對象中提?。ú东@）當前靜態數據集。

● 更改同步：為了使源數據與另一組數據同步，初始同步發生后，Extract捕獲DML和DDL操作。

從以下數據源中抽取捕獲：

●源表（如果運行是初始加載）。

●數據庫恢復日志或事務日志（例如Oracle重做日志或SQL / MX審計跟蹤）。從日志中捕獲的實際方法取決于數據庫類型。

●第三方捕獲模塊。此方法提供了一個通信層，該通信層將數據和元數據從外部API傳遞到Extract API。數據庫供應商或第三方供應商提供提取數據操作并將其傳遞給Extract的組件。

為更改同步配置時，Extract捕獲對Extract配置中的對象執行的DML和DDL操作。Extract存儲這些操作，直到它接收到包含這些

操作的事務的提交記錄或回滾。當接收到回滾時，Extract將放棄該事務的操作。 當接收到提交時，Extract將事務持久化到一系列

稱為trail的文件中的磁盤，在這些文件中，事務排隊等待傳播到目標系統。每個事務中的所有操作都作為順序組織的事務單元寫入

trail。這個 設計確保速度和數據完整性。

注意即使同一事務可能還包括對在提取配置中的對象的操作，提取也將忽略不在提取配置中的對象的操作。

多個提取過程可以同時對不同的對象進行操作。例如，

兩個提取過程可以并行提取和傳輸兩個復制過程（兩個持久性跟蹤）當數據庫很大時，將目標延遲最小化。要區分不同的提取過程，請為每個過程分配一個組名（請參閱第16頁的“組概述”）。

Overview of data pumps

數據泵概述

A data pump is a secondary Extract group within the source Oracle GoldenGate

configuration. If a data pump is not used, Extract must send the captured data operations

to a remote trail on the target. In a typical configuration with a data pump, however, the

primary Extract group writes to a trail on the source system. The data pump reads this

trail and sends the data operations over the network to a remote trail on the target. The

data pump adds storage flexibility and also serves to isolate the primary Extract process

from TCP/IP activity.

數據泵是源端Oracle GoldenGate配置中的輔助抽取組

如果不使用數據泵，Extract必須將捕獲的數據操作發送到目標上的遠程跟蹤，

然而，在典型的數據泵配置中 primary Extract group在源系統上寫入跟蹤。

數據泵讀取此跟蹤并將數據操作通過網絡發送到目標上的遠程跟蹤。

數據泵增加了存儲靈活性，還可以隔離主提取過程來自TCP / IP活動。

In general, a data pump can perform data filtering, mapping, and conversion, or it can be

configured in pass-through mode, where data is passively transferred as-is, without

manipulation. Pass-through mode increases the throughput of the data pump, because all

of the functionality that looks up object definitions is bypassed.

In most business cases, you should use a data pump. Some reasons for using a data pump

include the following:

通常，數據泵可以執行數據過濾，映射和轉換，也可以配置為直通模式，在這種模式下，數據按原樣被動傳輸，而無需進行操作。直通模式可提高數據泵的吞吐量，因為所有查找對象定義的功能中的一部分被繞過了。在大多數業務情況下，應使用數據泵。使用數據泵的一些原因包括以下這些：

● Protection against network and target failures: In a basic Oracle GoldenGate

configuration, with only a trail on the target system, there is nowhere on the source

system to store the data operations that Extract continuously extracts into memory. If

the network or the target system becomes unavailable, Extract could run out of

memory and abend. However, with a trail and data pump on the source system,

captured data can be moved to disk, preventing the abend of the primary Extract.

When connectivity is restored, the data pump captures the data from the source trail

and sends it to the target system(s).

●防止網絡和目標故障：在基本的Oracle GoldenGate配置中，只有目標系統上的一條線索，源系統上沒有任何地方可以存儲連續提取到內存中的數據操作。如果網絡或目標系統不可用，提取可能會耗盡內存和異常終止。但是，通過源系統上的trail和data pump，捕獲的數據可以移動到磁盤，從而防止主提取的異常終止。當連接恢復時，data pump從源trail 捕獲數據并將其發送到目標系統。

● You are implementing several phases of data filtering or transformation. When using

complex filtering or data transformation configurations, you can configure a data pump

to perform the first transformation either on the source system or on the target system,

or even on an intermediary system, and then use another data pump or the Replicat

group to perform the second transformation.

● 您正在實現數據過濾或轉換的幾個階段。當使用復雜的過濾或數據轉換配置時，可以配置數據泵

要在源系統或目標系統上執行第一個轉換， 甚至在中間系統上，然后使用另一個數據泵或Replicat組執行第二次轉換。

● Consolidating data from many sources to a central target. When synchronizing multiple

source databases with a central target database, you can store extracted data

operations on each source system and use data pumps on each of those systems to send

the data to a trail on the target system. Dividing the storage load between the source

and target systems reduces the need for massive amounts of space on the target system

to accommodate data arriving from multiple sources.

● 將來自許多來源的數據整合到一個中心目標。將多個源數據庫與中央目標數據庫同步時，可以在每個源系統上存儲提取的數據操作，并在每個系統上使用數據泵進行發送數據到目標系統上的路徑。在源系統和目標系統之間分配存儲負載可以減少目標系統上需要大量空間來容納來自多個源的數據。

● Synchronizing one source with multiple targets. When sending data to multiple target

systems, you can configure data pumps on the source system for each target. If network

connectivity to any of the targets fails, data can still be sent to the other targets.

● 同步一個源和多個目標。向多個目標系統發送數據時，可以在源系統上為每個目標配置數據泵。

如果到任何目標的網絡連接失敗，數據仍可以發送到其他目標

Overview of Replicat

復制概述

The Replicat process runs on the target system, reads the trail on that system, and then

reconstructs the DML or DDL operations and applies them to the target database. You can

configure Replicat in one of the following ways:

Replicat進程在目標系統上運行，讀取該系統上的隊列，然后重現DML或DDL操作并將其應用于目標數據庫。

您可以通過以下方式之一配置Replicat：

● Initial loads: For initial data loads, Replicat can apply a static data copy to target objects

or route it to a high-speed bulk-load utility.

●初始加載：對于初始數據加載，Replicat可以將靜態數據副本應用于目標對象或將其路由到高速大容量加載實用程序。

● Change synchronization: When configured for change synchronization, Replicat applies

the replicated source operations to the target objects using a native database interface

or ODBC, depending on the database type. To preserve data integrity, Replicat applies

the replicated operations in the same order as they were committed to the source

database.

●更改同步：當配置為更改同步時，Replicat使用本機數據庫接口或ODBC將復制的源操作應用于目標對象，具體取決于數據庫類型。為了保持數據完整性，Replicat按照提交給源數據庫的相同順序應用復制的操作。

You can use multiple Replicat processes with multiple Extract processes in parallel to

increase throughput. To preserve data integrity, each set of processes handles a different

set of objects. To differentiate among Replicat processes, you assign each one a group name

(see “Overview of groups” on page 16).

您可以將多個復制進程與多個提取進程并行使用，以提高吞吐量。為了保持數據完整性，每個進程集處理不同的對象集。為了區分復制進程，您為每個進程分配一個組名（參見第16頁的“組概述”）。

You can delay Replicat so that it waits a specific amount of time before applying the

replicated operations to the target database. A delay may be desirable, for example, to

prevent the propagation of errant SQL, to control data arrival across different time zones,

or to allow time for other planned events to occur. The length of the delay is controlled by

the DEFERAPPLYINTERVAL parameter.

您可以延遲Replicat，以便它在將復制操作應用于目標數據庫之前等待特定的時間量。延遲可能是可取的，例如，為了防止

錯誤的SQL的傳播，為了控制跨不同時區的數據到達， 或者留出時間讓其他計劃的事件發生。延遲的長度由DEFERAPPLYINTERVAL

參數控制。

Overview of trails

隊列概述

To support the continuous extraction and replication of database changes, Oracle

GoldenGate stores records of the captured changes temporarily on disk in a series of files

called a trail. A trail can exist on the source system, an intermediary system, the target

system, or any combination of those systems, depending on how you configure Oracle

GoldenGate. On the local system it is known as an extract trail (or local trail). On a remote

system it is known as a remote trail.

為了支持連續提取和復制數據庫更改，Oracle GoldenGate將捕獲的更改的記錄臨時存儲在磁盤上稱為trail的一系列文件中。路徑可以存在于源系統，中間系統，目標系統或這些系統的任意組合，具體取決于您配置Oracle GoldenGate的方式。在本地系統上，它稱為抽取路徑（或本地路徑）。在遠程系統上，它稱為遠程路徑。

By using a trail for storage, Oracle GoldenGate supports data accuracy and fault tolerance

(see “Overview of checkpoints” on page 14). The use of a trail also allows extraction and

replication activities to occur independently of each other. With these processes separated,

you have more choices for how data is processed and delivered. For example, instead of

extracting and replicating changes continuously, you could extract changes continuously

but store them in the trail for replication to the target later, whenever the target

application needs them.

通過使用trail隊列進行存儲，Oracle GoldenGate支持數據準確性和容錯性 （見第14頁“檢查點概述”）。trail的使用

還允許提取和復制活動彼此獨立地進行。有了這些分離的進程， 對于如何處理和傳遞數據，您有更多的選擇。例如，您可

以連續抽取變化而將它們存儲在trail中，而不是連續抽取和復制 ，以便以后在目標應用程序需要時復制到目標

Processes that write to, and read, a trail

寫入和讀取隊列的進程

The primary Extract and the data-pump Extract write to a trail. Only one Extract process

can write to a trail, and each Extract must be linked to a trail.

主抽取和數據泵抽取寫入隊列。只有一個提取過程可以寫入隊列，并且每個提取必須鏈接到一個隊列。

Processes that read the trail are:

讀取隊列的進程包括：

● Data-pump Extract: Extracts DML and DDL operations from a local trail that is linked

to a previous Extract (typically the primary Extract), performs further processing if

needed, and transfers the data to a trail that is read by the next Oracle GoldenGate

process downstream (typically Replicat, but could be another data pump if required).

●數據泵提?。簭逆溄拥缴弦粋€抽?。ㄍǔＪ侵鞒槿。┑谋镜仃犃兄刑崛ML和DDL操作，如果需要，執行進一步的處理，并將數據傳輸到下一個Oracle GoldenGate進程下游讀取的隊列（通常是復制，但如果需要，可以是另一個數據泵）。

● Replicat: Reads the trail and applies replicated DML and DDL operations to the target

database.

● Replicat：讀取隊列并將復制的DML和DDL操作應用于目標數據庫

Trail creation and maintenance

隊列創建和維護

The trail files themselves are created as needed during processing, but you specify a two-

character name for the trail when you add it to the Oracle GoldenGate configuration with

the ADD RMTTRAIL or ADD EXTTRAIL command. By default, trails are stored in the dirdat sub-

directory of the Oracle GoldenGate directory.

隊列文件本身是在進程中根據需要創建的，但是當使用以下方式將其添加到Oracle GoldenGate配置中時，可以為該隊列指定一個兩個字符的名稱：ADD RMTTRAIL或ADD EXTTRAIL命令。缺省情況下，隊列存儲在Oracle GoldenGate目錄的dirdat子目錄中。

Full trail files are aged automatically to allow processing to continue without interruption

for file maintenance. As each new file is created, it inherits the two-character trail name

appended with a unique, six-digit sequence number from 000000 through 999999 (for

example c: \ggs\dirdat\tr000001 ). When the sequence number reaches 999999, the numbering

starts over at 000000.

完整的隊列文件會自動老化，以便在不中斷 文件維護中進程持續。在創建每個新文件時，它將繼承兩個字符的trail名稱，

并附加一個從000000到999999的唯一六位序列號（例如c:\ ggs\dirdat\tr000001）。當序列號達到999999時 從000000

重新開始。

You can create more 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

trail that is specified with an EXTTRAIL or RMTTRAIL parameter in the Extract parameter file.

Aged trail files can be purged by using the Manager parameter PURGEOLDEXTRACTS .

To maximize throughput, and to minimize I/O load on the system, extracted data is sent

into and out of a trail in large blocks. Transactional order is preserved. By default, Oracle

GoldenGate writes data to the trail in canonical format, a proprietary format which allows

it to be exchanged rapidly and accurately among heterogeneous databases. However, data

can be written in other formats that are compatible with different applications.

For additional information about the trail and the records it contains, see Appendix 2 on

page 562.

您可以創建多條隊列以將數據從不同的對象或應用程序中分離出來。將表或序列參數中指定的對象鏈接到提取參數文件中

使用EXTTRAIL或RMTTRAIL參數指定的軌跡。 可以使用管理器參數PURGEOLDEXTRACTS清除過時的隊列文件。

為了最大化吞吐量和最小化系統上的I/O負載，提取的數據以大數據塊的形式發送到和發送出一條路徑。事務順序被保留。

默認情況下， Oracle GoldenGate以規范格式將數據寫入trail，這是一種專有格式，允許在異構數據庫之間快速、準確地交

換數據。但是，數據 可以用與不同應用程序兼容的其他格式編寫。 有關跟蹤及其包含的記錄的更多信息，請參閱第562頁的

附錄2。

Overview of extract files

抽取文件概述

In some configurations, Oracle GoldenGate stores extracted data in an extract file instead

of a trail. The extract file can be a single file, or it can be configured to roll over into

multiple files in anticipation of limitations on file size that are imposed by the operating

system. In this sense, it is similar to a trail, except that checkpoints are not recorded. The

file or files are created automatically during the run. The same versioning features that

apply to trails also apply to extract files.

在某些配置中，Oracle GoldenGate將提取的數據存儲在抽取文件中而不是隊列中。提取文件可以是單個文件，也可以

配置為在預期操作系統會限制文件大小的情況下滾動成多個文件。從這個意義上講，它類似于隊列，不同之處在于不記錄

檢查點。一個或多個文件在運行期間自動創建。適用于隊列的相同版本控制功能也適用于提取文件。

Overview of checkpoints

檢查點概述

Checkpoints store the current read and write positions of a process to disk for recovery

purposes. Checkpoints ensure that data changes that are marked for synchronization

actually are captured by Extract and applied to the target by Replicat, and they prevent

redundant processing. They provide fault tolerance by preventing the loss of data should

the system, the network, or an Oracle GoldenGate process need to be restarted. For

complex synchronization configurations, checkpoints enable multiple Extract or Replicat

processes to read from the same set of trails.

Checkpoints work with inter-process acknowledgments to prevent messages from being

lost in the network. Oracle GoldenGate has a proprietary guaranteed-message delivery

technology.

檢查點將進程的當前讀寫位置存儲到磁盤以進行恢復目的。檢查點確保標記為同步的數據更改

實際上是由Extract捕獲的，并由Replicat應用于目標的，它們可以防止冗余處理。它們通過防

止數據丟失來提供容錯能力。系統，網絡或Oracle GoldenGate進程需要重新啟動。對于

復雜的同步配置，檢查點可啟用多個取抽或復制從同一組記錄讀取的過程。檢查點與進程間確認

一起使用，以防止消息被發送迷失在網絡中。 Oracle GoldenGate具有專有的保證消息交付技術。

Extract creates checkpoints for its positions in the data source and in the trail. Because

Extract only captures committed transactions, it must keep track of operations in all open

transactions, in the event that any of them are committed. This requires Extract to record

a checkpoint where it is currently reading in a transaction log, plus the position of the start

of the oldest open transaction, which can be in the current or any preceding log.

Extract為其在數據源和隊列中的位置創建檢查點。因為 Extract只捕獲提交的事務，它必須跟蹤所有打開的操作

事務，如果其中任何一個已提交。這需要摘錄來記錄 當前在事務日志中讀取的檢查點，加上開始位置 最早的打開

事務，可以在當前日志或任何前面的日志中。

To control the amount of transaction log that must be re-processed after an outage, Extract

persists the current state and data of processing to disk at specific intervals, including the

state and data (if any) of long-running transactions. If Extract stops after one of these

intervals, it can recover from a position within the previous interval or at the last

checkpoint, instead of having to return to the log position where the oldest open long-

running transaction first appeared. For more information, see the BR parameter in the

Oracle GoldenGate Windows and UNIX Reference Guide.

要控制中斷后必須重新處理的事務日志量，請抽取 以特定的間隔將當前處理狀態和數據持久化到磁盤，包括

長期運行事務的狀態和數據（如果有）。如果提取在其中一個之后停止 間隔，它可以從上一個間隔或最后一個

間隔內的位置恢復 檢查點，而不必返回到最早打開long的日志位置- 首次出現運行事務。有關詳細信息，請參見

《Oracle GoldenGate Windows和UNIX參考指南》。

Replicat creates checkpoints for its position in the trail. Replicat stores its checkpoints in

a checkpoint table in the target database to couple the commit of its transaction with its

position in the trail file. The checkpoint table guarantees consistency after a database

recovery by ensuring that a transaction will only be applied once, even if there is a failure

of the Replicat process or the database process. For reporting purposes, Replicat also has

a checkpoint file on disk in the dirchk sub-directory of the Oracle GoldenGate directory.

Replicat為它在trail中的位置創建檢查點。Replicat將其檢查點存儲在 目標數據庫中的檢查點表，用于將其

事務的提交與 在軌跡文件中的位置。檢查點表保證數據庫之后的一致性 通過確保事務只應用一次（即使出現

故障）來恢復 復制進程或數據庫進程的。出于報告的目的，Replicat還有 磁盤上Oracle GoldenGate目錄的

dirchk子目錄中的檢查點文件。

Checkpoints are not required for non-continuous types of configurations that can be re-run

from a start point if needed, such as initial loads.

對于可以重新運行的非連續類型的配置，不需要檢查點 如果需要，從起點開始，例如初始負載。

Overview of Manager

manager概述

Manager is the control process of Oracle GoldenGate. Manager must be running on each

system in the Oracle GoldenGate configuration before Extract or Replicat can be started,

and Manager must remain running while those processes are running so that resource

management functions are performed. Manager performs the following functions:

Manager是Oracle GoldenGate的控制過程。必須在Oracle GoldenGate配置中的每個系統上運行管理器，然后才能

啟動提取或復制， 當這些進程運行時，管理器必須保持運行，以便 執行管理功能。管理器執行以下功能：

● Start Oracle GoldenGate processes

● Start dynamic processes

● Maintain port numbers for processes

● Perform trail management

● Create event, error, and threshold reports

One Manager process can control many Extract or Replicat processes. On Windows

systems, Manager can run as a service. For more information about the Manager process

and configuring TCP/IP connections, see Chapter 3.

一個管理器進程可以控制多個提取或復制進程。在Windows系統上，Manager可以作為服務運行。有關管理器進程和配置TCP/IP連接的更多信息，請參閱第3章。

Overview of Collector

Collector概述

Collector is a process that runs in the background on the target system when continuous,

online change synchronization is active. Collector does the following:

收集器是一個進程，當連續的聯機更改同步處于活動狀態時，該進程在目標系統的后臺運行。收集器執行以下操作：

● Upon a connection request from a remote Extract to Manger, scan and bind to an

available port and then send the port number to Manager for assignment to the requesting Extract process.

●從遠程提取到管理器的連接請求后，掃描并綁定到可用端口，然后將端口號發送給管理器，以便分配到請求提取過程。

● Receive extracted database changes that are sent by Extract and write them to a trail

file. Manager starts Collector automatically when a network connection is required, so

Oracle GoldenGate users do not interact with it. Collector can receive information from

only one Extract process, so there is one Collector for each Extract that you use.

Collector terminates when the associated Extract process terminates.

接收通過提取發送的提取數據庫更改，并將其寫入跟蹤文件。當需要網絡連接時，Manager會自動啟動收集器，因此

Oracle GoldenGate用戶不會與其交互。收集器可以從僅 一個抽取過程進程接收信息，因此您使用的每個提取都有一個

收集器。 當關聯的提取進程終止時，收集器終止。

NOTE Collector can be run manually, if needed. This is known as a static Collector (as

opposed to the regular, dynamic Collector). Several Extract processes can share

one static Collector; however, a one-to-one ratio is optimal. A static Collector can

be used to ensure that the process runs on a specific port. For more information

about the static Collector, see the Oracle GoldenGate Windows and UNIX

Reference Guide. For more information about how Manager assigns ports, see

Chapter 3.

如果需要，可以手動運行便箋收集器。這稱為靜態收集器（與常規的動態收集器相反）。

多個提取進程可以共享一個靜態收集器；但是，一對一的比率是最佳的。靜電收集器

用于確保進程在特定端口上運行。有關靜態收集器的詳細信息，請參閱《Oracle GoldenGate Windows和UNIX參考指南》。有關Manager如何分配端口的詳細信息，請參閱

第三章。

By default, Extract initiates TCP/IP connections from the source system to Collector on the

target, but Oracle GoldenGate can be configured so that Collector initiates connections

from the target. Initiating connections from the target might be required if, for example,

the target is in a trusted network zone, but the source is in a less trusted zone. For

information about this configuration, see page 136.

默認情況下，“提取”會啟動從源系統到目標上收集器的TCP/IP連接，但可以配置Oracle GoldenGate，以便收集器從

目標啟動連接?？赡苄枰獜哪繕藛舆B接，例如， 目標位于受信任的網絡區域，但源位于不受信任的區域。為了 有關此

配置的信息，請參閱第136頁。

Overview of process types

進程類型概述

Depending on the requirement, Oracle GoldenGate can be configured with the following processing types.

根據需要，Oracle GoldenGate可以配置以下處理類型。

● An online Extract or Replicat process runs until stopped by a user. Online processes

maintain recovery checkpoints in the trail so that processing can resume after

interruptions. You use online processes to continuously extract and replicate DML and

DDL operations (where supported) to keep source and target objects synchronized. The

EXTRACT and REPLICAT parameters apply to this process type.

● A source-is-table Extract process extracts a current set of static data directly from the

source objects in preparation for an initial load to another database. This process type

does not use checkpoints. The SOURCEISTABLE parameter applies to this process type.

● A special-run Replicat process applies data within known begin and end points. You

use a special Replicat run for initial data loads, and it also can be used with an online

Extract to apply data changes from the trail in batches, such as once a day rather than

continuously. This process type does not maintain checkpoints, because the run can be

started over with the same begin and end points. The SPECIALRUN parameter applies to

this process type.

● A remote task is a special type of initial-load process in which Extract communicates

directly with Replicat over TCP/IP. Neither a Collector process nor temporary disk

storage in a trail or file is used. The task is defined in the Extract parameter file with

the RMTTASK parameter.

●在線提取或復制過程一直運行到用戶停止為止。聯機進程在跟蹤中維護恢復檢查點，以便在中斷后恢復處理。您可以使用聯機過程連續提取和復制DML和

DDL操作（如果支持）以保持源對象和目標對象同步。EXTRACT和REPLICAT參數應用于此進程類型。

●source-is-table提取過程直接從源對象中提取一組當前靜態數據，以準備初始加載到另一個數據庫。此進程類型不使用檢查點。SOURCEISTABLE參數應用于此進程類型。

●特殊運行復制過程在已知起點和終點內應用數據。您可以使用一個特殊的Replicat run來加載初始數據，它還可以與一個聯機提取一起使用，以成批應用來自trail的數據更改，

例如每天一次，而不是 連續不斷地。此進程類型不維護檢查點，因為可以使用相同的起點和終點重新開始運行。SPECIALRUN參數適用于此進程類型。

●遠程任務是一種特殊類型的初始加載過程，其中Extract與 直接通過TCP/IP復制。不使用收集器進程或跟蹤或文件中的臨時磁盤存儲。任務在提取參數文件中用RMTTASK參數定義。

Overview of groups

groups概述

To differentiate among multiple Extract or Replicat processes on a system, you define

processing groups. For example, to replicate different sets of data in parallel, you would

create two Replicat groups.

要區分系統上的多個提取或復制進程，請定義處理組。例如，要并行復制不同的數據集，可以創建兩個復制組。

A processing group consists of a process (either Extract or Replicat), its parameter file, its

checkpoint file, and any other files associated with the process. For Replicat, a group also

includes the associated checkpoint table.

一個進程組由進程（Extract或Replicat）、其參數文件、檢查點文件和與該進程關聯的任何其他文件組成。對于Replicat，組還包含關聯的檢查點表。

You define groups by using the ADD EXTRACT and ADD REPLICAT commands in the Oracle

GoldenGate command interface, GGSCI. For permissible group names, see those

commands in the Oracle GoldenGate Windows and UNIX Reference Guide.

您可以使用OracleGoldenGate命令界面中的ADD EXTRACT和ADD REPLICAT命令來定義組。有關允許的組名，請參閱《Oracle GoldenGate Windows和UNIX參考指南》中的這些命令。

All files and checkpoints relating to a group share the name that is assigned to the group

itself. Any time that you issue a command to control or view processing, you supply a group

name or multiple group names by means of a wildcard.

與組相關的所有文件和檢查點共享分配給組本身的名稱。在發出控制或查看處理的命令時，可以通過通配符提供組名或多個組名

Overview of the Commit Sequence Number (CSN)

提交序列號（CSN）概述

使用Oracle GoldenGate時，可能需要引用提交序列號或CSN。CSN是Oracle GoldenGate為維護事務一致性和數據完整性而

構造的用于標識事務的標識符。 它 唯 一標識事務提交到數據庫的時間點。 可以要求CSN在事務日志中定位Extract，以重新定位

Replicat 在隊列上，或為了其他目的。它由一些轉換函數返回，并且 包括在報告和某些GGSCI輸出中。 有關CSN和每個數據庫的

CSN值列表的更多信息，請參見附錄 第559頁。