Oracle GoldenGate 学习教程三、加密(3)

分析GoldenGate Data Pump进程

GGSCI (sywu) 11> stats PSYDB001 Sending STATS request to EXTRACT PSYDB001 ... Start of Statistics at 2015-08-31 17:32:14. Output to /u01/app/product/ogg_trg/dirdat/ps: Extracting from OGG_OWNER.TOGG to OGG_OWNER.TOGG: *** Total statistics since 2015-08-31 17:29:53 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Daily statistics since 2015-08-31 17:29:53 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Hourly statistics since 2015-08-31 17:29:53 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Latest statistics since 2015-08-31 17:29:53 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 End of Statistics. GGSCI (sywu) 12> info PSYDB001,detail EXTRACT PSYDB001 Last Started 2015-08-31 17:17 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:01 ago) Process ID 31884 Log Read Checkpoint File /u01/app/product/ogg_src/dirdat/es000007 2015-08-31 17:29:49.000000 RBA 1865 Target Extract Trails: Trail Name Seqno RBA Max MB Trail Type /u01/app/product/ogg_trg/dirdat/ps 10 2043 100 RMTTRAIL Extract Source Begin End /u01/app/product/ogg_src/dirdat/es000007 2015-08-26 10:04 2015-08-31 17:29 /u01/app/product/ogg_src/dirdat/es000004 2015-08-26 10:04 2015-08-26 10:04 /u01/app/product/ogg_src/dirdat/es000004 2015-08-26 10:04 2015-08-26 10:04 /u01/app/product/ogg_src/dirdat/es000004 2015-08-26 10:04 2015-08-26 10:04 /u01/app/product/ogg_src/dirdat/es000004 2015-08-26 10:04 2015-08-26 10:04 /u01/app/product/ogg_src/dirdat/es000004 2015-08-26 10:04 2015-08-26 10:04 /u01/app/product/ogg_src/dirdat/es000004 * Initialized * 2015-08-26 10:04 /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record Current directory /u01/app/product/ogg_src Report file /u01/app/product/ogg_src/dirrpt/PSYDB001.rpt Parameter file /u01/app/product/ogg_src/dirprm/psydb001.prm Checkpoint file /u01/app/product/ogg_src/dirchk/PSYDB001.cpe Process file /u01/app/product/ogg_src/dirpcs/PSYDB001.pce Error log /u01/app/product/ogg_src/ggserr.log

源端Data Pump进程从主抽取进程保存的trail文件中读取到两条插入信息，它读取的trail文件是:/u01/app/product/ogg_src/dirdat/es000007；注意它们的工作原理，主抽取进程抽取数据加密并保存到trail文件，Data Pump进程读取trail文件解密再进行数据操作，最后发送；

[oracle@sywu ~]$ strings /u01/app/product/ogg_src/dirdat/es000007 *uri:sywu::u01:app:product:ogg_src:ESYDB0016 (/u01/app/product/ogg_src/dirdat/es0000077 597066 ,............................................ Linux1 sywu2 2.6.32-431.23.3.el6.x86_643 ##1 SMP Thu Jul 31 17:20:51 UTC 20144 x86_642 SYDB2 sydb3 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production 11.2.0.3.09 +08:003 ESYDB0011 AVersion 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO4 ESYDB001Z OGG_OWNER.TOGG AAADX2AAGAAAAA7AAA 5981816 1.86.100Z OGG_OWNER.TOGG uaDL AAADX2AAGAAAAA7AAB

数据加密了，看不到了。
源端replicat进程信息

[oracle@sywu ogg_src]$ tggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO Linux, x64, 64bit (optimized), Oracle 11g on Aug 7 2014 09:14:25 Operating system character set identified as UTF-8. Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved. GGSCI (sywu) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING RSYDB001 00:00:00 00:00:03 GGSCI (sywu) 4> stats RSYDB001 Sending STATS request to REPLICAT RSYDB001 ... Start of Statistics at 2015-08-31 18:40:08. Replicating from OGG_OWNER.TOGG to OGG_TRG.TOGG: *** Total statistics since 2015-08-31 17:30:03 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Daily statistics since 2015-08-31 17:30:03 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Hourly statistics since 2015-08-31 18:00:00 *** No database operations have been performed. *** Latest statistics since 2015-08-31 17:30:03 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 End of Statistics. GGSCI (sywu) 2> info RSYDB001,detail REPLICAT RSYDB001 Last Started 2015-08-31 17:16 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:05 ago) Process ID 31615 Log Read Checkpoint File /u01/app/product/ogg_trg/dirdat/ps000010 2015-08-31 17:29:49.000465 RBA 2043 Current Log BSN value: (requires database login) Last Committed Transaction CSN value: (requires database login) Extract Source Begin End /u01/app/product/ogg_trg/dirdat/ps000010 2015-08-26 10:04 2015-08-31 17:29 /u01/app/product/ogg_trg/dirdat/ps000008 2015-08-26 09:52 2015-08-26 10:04 /u01/app/product/ogg_trg/dirdat/ps000008 2015-08-25 13:58 2015-08-26 09:52 /u01/app/product/ogg_trg/dirdat/ps000006 2015-08-25 13:49 2015-08-25 13:58 /u01/app/product/ogg_trg/dirdat/ps000006 2015-08-25 13:49 2015-08-25 13:49 /u01/app/product/ogg_trg/dirdat/ps000006 2015-08-25 13:49 2015-08-25 13:49 /u01/app/product/ogg_trg/dirdat/ps000006 * Initialized * 2015-08-25 13:49 /u01/app/product/ogg_trg/dirdat/ps000006 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record Current directory /u01/app/product/ogg_trg Report file /u01/app/product/ogg_trg/dirrpt/RSYDB001.rpt Parameter file /u01/app/product/ogg_trg/dirprm/rsydb001.prm Checkpoint file /u01/app/product/ogg_trg/dirchk/RSYDB001.cpr Checkpoint table OGG_TRG.OGG_CHK Process file /u01/app/product/ogg_trg/dirpcs/RSYDB001.pcr Error log /u01/app/product/ogg_trg/ggserr.log