# inserts: 2

# updates: 0

# deletes: 0

# discards: 0?

gc2:确认初始化数据（由gc1传输而来）

SQL>conn scott/tiger

Connected.

SQL>select * from tcustmer;

CUST NAME CITY ST

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

WILL BG SOFTWARE CO. SEATTLE WA

JANE ROCKY FLYER INC. DENVER CO

SQL>set linesize 200

SQL>select * from tcustord

CUST ORDER_DATE PRODUCT_ ORDER_ID PRODUCT_PRICEPRODUCT_AMOUNT TRANSACTION_ID

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

WILL 30-SEP-94 CAR 144 17520 3 100

JANE 11-NOV-95 PLANE 256 133300 1 100

--从源端到目标端数据初始化成功

--数据初始完成后，源端Extract进程、目标端Replicat进程自动停止

gc1：检查Extract进程状态

GGSCI(gc1) 13> INFO EXTRACT EINI_1

EXTRACT EINI_1 Last Started 2014-06-1810:13 Status STOPPED

Checkpoint Lag Not Available

Log Read Checkpoint Table SCOTT.TCUSTORD

2014-06-18 10:13:53 Record 2

Task SOURCEISTABLE?

gc2：检查Replicat进程状态

GGSCI(gc2) 1> INFO REPLICAT RINI_1

REPLICAT RINI_1 Initialized 2014-06-18 10:03 Status STOPPED

Checkpoint Lag 00:00:00 (updated 00:21:01 ago)

Log Read Checkpoint Not Available

Task SPECIALRUN?

gc1：配置Extract进程

GGSCI(gc1) 14> EDIT PARAMS EORA_1

-- Change Capture parameter file to capture

-- TCUSTMER and TCUSTORD changes

EXTRACT EORA_1

SETENV (NLS_LANG= AMERICAN_AMERICA.ZHS16GBK)

USERID ogg, PASSWORD Ogg

EXTTRAIL ./dirdat/aa

TABLE scott.TCUSTMER;

TABLE scott.TCUSTORD;

~

~

~

"dirprm/eora_1.prm" [New] 8L, 228Cwritten

GGSCI(gc1) 15> ADD EXTRACT EORA_1, TRANLOG, BEGIN NOW

EXTRACT added.

GGSCI(gc1) 16> ADD EXTTRAIL ./dirdat/aa, EXTRACT EORA_1, MEGABYTES 5

EXTTRAIL added.

GGSCI(gc1) 17> START EXTRACT EORA_1

Sending START request to MANAGER ...

EXTRACT EORA_1 starting

GGSCI(gc1) 18> INFO EXTRACT EORA_1

EXTRACT EORA_1 Last Started 2014-06-1810:29 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:00 ago)

Log Read Checkpoint Oracle Redo Logs

2014-06-18 10:29:19 Seqno 16, RBA 1328640

[oracle@gc1ogg]$ ll /u01/app/ogg/dirdat/ --验证跟踪文件

total 4

-rw-rw-rw- 1 oracle oinstall 893 Jun 18 10:29 aa000000?

gc1：配置Pump进程

GGSCI(gc1) 1> EDIT PARAMS PORA_1

-- Data Pump parameter file to read the local

-- trail of TCUSTMER and TCUSTORD changes

--

EXTRACT PORA_1

SETENV (NLS_LANG= AMERICAN_AMERICA.ZHS16GBK)

PASSTHRU

RMTHOST gc2, MGRPORT 7809

RMTTRAIL ./dirdat/pa

TABLE scott.TCUSTMER;

TABLE scott.TCUSTORD;

~

~

"dirprm/pora_1.prm" [New] 10L, 253Cwritten

GGSCI(gc1) 2> ADD EXTRACT PORA_1, EXTTRAILSOURCE ./dirdat/aa

EXTRACT added.

GGSCI(gc1) 3> INFO EXTRACT PORA_1

EXTRACT PORA_1 Initialized 2014-06-18 10:35 Status STOPPED

Checkpoint Lag 00:00:00 (updated 00:00:14 ago)

Log Read Checkpoint File ./dirdat/aa000000

First Record RBA 0

GGSCI(gc1) 4> ADD RMTTRAIL ./dirdat/pa, EXTRACT PORA_1, MEGABYTES 5

RMTTRAIL added.

GGSCI(gc1) 5> START EXTRACT PORA_1

Sending START request to MANAGER ...

EXTRACT PORA_1 starting

GGSCI(gc1) 6> INFO EXTRACT PORA_1

EXTRACT PORA_1 Last Started 2014-06-1810:36 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:04 ago)

Log Read Checkpoint File ./dirdat/aa000000

First Record RBA 0?

gc2：验证gc1Pump进程配置

[oracle@gc2ogg]$ ll dirdat/ --在目标端生成名为pa000000的追踪文件

total 0

-rw-rw-rw- 1 oracle oinstall 0 Jun 18 10:36pa000000?

gc2：配置Checkpoint

GGSCI(gc2) 1> EDIT PARAMS ./GLOBALS

CHECKPOINTTABLE ogg.ggschkpt

~

"./GLOBALS" [New] 1L, 29C written

[oracle@gc2ogg]$ ll GLOBALS --检查参数已添加