Shulou(Shulou.com)06/01 Report--

Extraction process:

Extract ext_code

SETENV (NLS_LANG= "AMERICAN_AMERICA.AL32UTF8")

SETENV (ORACLE_HOME = "/ app/oracle/product/10.2.0/db")

SETENV (ORACLE_SID = chunqiu)

Userid goldengate@chunqiu,password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCRYPTKEY DEFAULT

Exttrail. / dirdat/de

-- tranlogoptions excludeuser goldengate

Dynamicresolution

WARNLONGTRANS 3h, CHECKINTERVAL 30m

Gettruncates

Tranlogoptions altarchivelogdest + DG1/gbbarcode/archivelog/

TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle

Table chunqiu.plm_acc_serial

Table chunqiu.plm_acc_serial_tsc

ADD EXTRACT ext_code,tranlog,BEGIN now

ADD exttrail. / dirdat/de,EXTRACT ext_code,megabytes 200

Pump process:

Extract pum_code

SETENV (NLS_LANG= "AMERICAN_AMERICA.AL32UTF8")

SETENV (ORACLE_HOME = "/ app/oracle/product/10.2.0/db")

SETENV (ORACLE_SID = chunqiu)

Userid goldengate@chunqiu,password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCR

YPTKEY DEFAULT

Rmthost 192.168.50.68, mgrport 7801

Rmttrail. / dirdat/cc

PASSTHRU

Gettruncates

Table chunqiu.plm_acc_serial

Table chunqiu.plm_acc_serial_tsc

ADD EXTRACT pum_code,exttrailsource. / dirdat/de

ADD rmttrail. / dirdat/cc,EXTRACT pum_code,megabytes 200

Application process:

Database modification parameters. You do not need to set the enable_goldengate_replication parameter before 11g:

Alter system set enable_goldengate_replication=true scope=both

Add goldengate users to the database:

Create tablespace OGG_TBS datafile size 10G autoextend on next 100m maxsize unlimited

Create user goldengate default tablespace OGG_TBS identified by goldengate

Grant dba to goldengate

Add the checkpoint table:

Dblogin userid goldengate,password goldengate

Add checkpointtable goldengate.checkpoint

EDIT PARAMS. / GLOBALS

CHECKPOINTTABLE goldengate.checkpoint

Replicat rep_code

SETENV (NLS_LANG= "AMERICAN_AMERICA.AL32UTF8")

Userid goldengate,password goldengate

Assumetargetdefs

Reperror default,discard

Discardfile / goldengate/rep_code.log,append,megabytes 1000

Gettruncates

Map chunqiu.PLM_ACC_SERIAL, target idc.PLM_ACC_SERIAL

Map chunqiu.PLM_ACC_SERIAL_TSC, target idc.PLM_ACC_SERIAL_TSC

Add replicat rep_code,exttrail. / dirdat/cc, checkpointtable goldengate.checkpoint

Start rep_code,aftercsn 112892036392

Delete the replicat process:

Note: be sure to log in to dblogin to the target database, otherwise you will be prompted to delete checkpoint table

Dblogin userid goldengate,password goldengate

Stop rep_code

Delete replicat rep_code

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.