golden state oracle,Oracle goldengate通用配置

一、理论

source

ADD EXTRACT , TRANLOG, BEGIN , [, THREADS]

ADD EXTTRAIL , EXTRACT

EDIT PARAMS

-- Identify the Extract group:

EXTRACT

-- Specify database login information as needed for the database:

[SOURCEDB ,][USERID [, PASSWORD ]]

-- Specify the local trail that this Extract writes to:

EXTTRAIL

-- Specify tables to be captured:

TABLE .

ADD EXTRACT , EXTTRAILSOURCE , BEGIN

ADD RMTTRAIL , EXTRACT

EDIT PARAMS

-- Identify the data pump group:

EXTRACT

-- Specify database login information as needed for the database:

[SOURCEDB ,][USERID [, PASSWORD ]]

-- Specify the name or IP address of the first target system:

RMTHOST , MGRPORT

-- Specify the remote trail on the first target system:

RMTTRAIL

-- Allow mapping, filtering, conversion or pass data through as-is:

[PASSTHRU | NOPASSTHRU]

-- Specify tables to be captured:

TABLE .

target

edit params ./GLOBALS

CHECKPOINTTABLE .

ADD REPLICAT , EXTTRAIL , BEGIN checkpointtable .

edit params

-- Identify the Replicat group:

REPLICAT

-- State whether or not source and target definitions are identical:

SOURCEDEFS | ASSUMETARGETDEFS

-- Specify database login information as needed for the database:

[TARGETDB ,] [USERID [, PASSWORD ]]

-- Specify error handling rules:

REPERROR (, )

-- Specify tables for delivery:

MAP .

二、配置实例

source

add extract extl,tranlog,begin now

ADD EXTTRAIL /u01/ogg/dirdat/rl, EXTRACT EXTL

ADD TRANDATA chf.objce_t

edit params extl

extract extl

SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")

userid ogg,password xifenfei

exttrail /u01/ogg/dirdat/rl

dynamicresolution

gettruncates

table chf.objce_t;

ADD EXTRACT pump1, EXTTRAILSOURCE /u01/ogg/dirdat/rl, BEGIN now

add rmttrail /u01/ogg/dirdat/rl extract pump1

edit params pump1

extract pump1

SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")

userid ogg, password xifenfei

rmthost 192.168.1.111, mgrport 7809

rmttrail /u01/ogg/dirdat/rl

PASSTHRU

gettruncates

table chf.objce_t;

target

edit params ./GLOBALS

CHECKPOINTTABLE ogg.chkpoint

ADD CHECKPOINTTABLE ogg.chkpoint

add replicat repl exttrail /u01/ogg/dirdat/rl,begin now,checkpointtable ogg.chkpoint

edit repl

replicat repl

SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")

userid ogg,password xifenfei

assumetargetdefs

reperror default,discard

discardfile /tmp/repsz.dsc,append,megabytes 100

gettruncates

map chf.objce_t, target chf.objce_t;