Ogg Add extract Process

In the standared Oracle Goldengate confiugration, one Extract group sends captured data over TCP/IP to a trail on the Targ Et system, where it is stored until processed by one Replicat group.

Illustrate as:

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s1.51cto.com/wyfs02/m01/79/a4/wkiol1axohqduummaabgjxkih0w705.png "title=" Image.png "alt=" Wkiol1axohqduummaabgjxkih0w705.png "/>

Source system

Configure the Extract Group

On source system, with the ADD EXTRACT command to create a EXTRACT group.

For example:

ADD EXTRACT ext, {tranlog | INTEGRATED Tranlog}, BEGIN <time> [, THREADS <n>]

On the source, with the ADD rmttrail command to specify a remote trail to being created on the target system

ADD rmttrail <remote_trail>, EXTRACT ext

On the source, with the EDIT PARAMS command to create a parameter file for the Extract group, include the following parame Ters plus any others this apply to your database environment.

EXAMPLE:

--identify the Extract group:

EXTRACT ext

--specify Database login information as need for the database

[Sourcedb <dsn_1>] [, USERID <user> [, PASSWORD <pw> [<encryption Options>]

--specify the name or IP address of the target system ADN optional encryption arcoss TCP/IP

Rmthost <target>, Mgrport <portnumber>, ENCRYPT <encryption options>

--specify the remote trail and encryption options on the target system:

Encrypttrail [<encrption Options>]

Rmttrail <remote_trail>

--specilfy tables to be captured:

TABLE <owner>.<table>;

This article is from the "DBA Sky" blog, so be sure to keep this source http://kevinora.blog.51cto.com/9406404/1734987

Ogg Add extract Process