由于网络故障导致OGG trail文件损坏的恢复案例
Nov032015
11月1日周日，刚刚带闺女去楼下晒太阳回来，就接到同事的电话，由于公司机房到M6机房的专线故障，导致OGG源端的PUMP进程挂掉，重启源端PUMP进程时遇到目标端trail文件损坏。在我接到电话时，同事已经将源端的trail文件拷贝到目标端，源端的PUMP进程可以启动，但是目标端的复制进程挂掉。
通过电话了解到，他的操作并没有问题，我远程连到服务器，查看源端的抽取进程和源端的传输进程状态都正常，目标段的复制进程已经挂掉。
REPLICAT ABENDED R_IVL 00:00:00 00:51:28
查看OGG的日志，观察错误原因及还原同事的操作过程，发现在10：38分，由于网络故障，源端PUMP进程挂掉。
2015-11-01 10:38:46 ERROR OGG-01232 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Receive TCP params error: TCP/IP error 104 (Connection reset by peer). 2015-11-01 10:38:46 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, p_ivl.prm: PROCESS ABENDING.
11：03分，同事重启PUMP进程，遇到目标端trail文件损坏，源端PUMP进程没有起来。
2015-11-01 11:03:23 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start P_IVL.
2015-11-01 11:03:23 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host sl010a-ivdb01 (START EXTRACT P_IVL ).
2015-11-01 11:03:23 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT P_IVL starting.
2015-11-01 11:03:23 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, p_ivl.prm: EXTRACT P_IVL starting.
2015-11-01 11:03:23 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2015-11-01 11:03:24 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/oracle/ggs/dirtmp.
2015-11-01 11:03:24 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, p_ivl.prm: EXTRACT P_IVL started.
2015-11-01 11:03:29 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Socket buffer size set to 27985 (flush size 27985).
2015-11-01 11:03:39 ERROR OGG-01031 Oracle GoldenGate Capture for Oracle, p_ivl.prm: There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "./dirdat/iv000005" (error 2, No such file or directory)).
2015-11-01 11:03:39 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, p_ivl.prm: PROCESS ABENDING.
11：34分，同事将源端trail文件拷贝到目标端后，源端PUMP进程可以启动。
2015-11-01 11:34:51 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start P_IVL.
2015-11-01 11:34:51 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host sl010a-ivdb01 (START EXTRACT P_IVL ).
2015-11-01 11:34:51 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT P_IVL starting.
2015-11-01 11:34:51 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, p_ivl.prm: EXTRACT P_IVL starting.
2015-11-01 11:34:51 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2015-11-01 11:34:51 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/oracle/ggs/dirtmp.
2015-11-01 11:34:51 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, p_ivl.prm: EXTRACT P_IVL started.
2015-11-01 11:34:56 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Socket buffer size set to 27985 (flush size 27985).
2015-11-01 11:34:56 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Recovery initialization completed for target file ./dirdat/iv000012, at RBA 21227584, CSN 117635277743.
2015-11-01 11:34:56 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Output file ./dirdat/iv is using format RELEASE 11.2.
2015-11-01 11:34:56 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Rolling over remote file ./dirdat/iv000013.
2015-11-01 11:34:56 INFO OGG-01054 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Recovery completed for target file ./dirdat/iv000013, at RBA 1449, CSN 117635277743.
2015-11-01 11:34:56 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, p_ivl.prm: Recovery completed for all targets.
我登录后按照同事的思路，从源端拷贝过来trail文件后，目标端应该可以直接应用，为什么会挂呢？查看目标端的错误日志，发现在11：03分5号trail文件损坏，查看目标端的复制进程检查点信息，发现目标端应用到第5号trail文件。
2015-11-01 11:03:24 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host <unknown> (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ). 2015-11-01 11:03:24 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically). 2015-11-01 11:03:24 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from SERVER on host localhost (REPORT 104517 7866). 2015-11-01 11:03:24 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7866). 2015-11-01 11:03:24 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds. 2015-11-01 11:03:29 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to :60996. 2015-11-01 11:03:29 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening ./dirdat/iv000005 (byte -1, current EOF 34211874). 2015-11-01 11:03:39 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "./dirdat/iv000005" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 85024. 2015-11-01 11:03:39 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to open file "./dirdat/iv000005" (error 2, No such file or directory). 2015-11-01 11:03:39 INFO OGG-01676 Oracle GoldenGate Collector for Oracle: Terminating after client disconnect.
目标端检查点信息：
GGSCI (SL010M6-DB-ERPDB1) 7> info R_IVL
REPLICAT R_IVL Last Started 2015-11-01 12:05 Status ABENDED
Checkpoint Lag 00:00:00 (updated 01:09:58 ago)
Log Read Checkpoint File ./dirdat/iv000005
2015-11-01 10:37:04.961394 RBA 34211874
目标端检查点信息停留在5号trail文件，在11：19分，同事停掉了目标端的复制进程。
2015-11-01 11:19:45 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop R_IVL. 2015-11-01 11:19:46 INFO OGG-01021 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Command received from GGSCI: STOP. 2015-11-01 11:19:46 INFO OGG-00994 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: REPLICAT R_IVL stopped normally.
在11：28分，同事从源端将tail文件拷贝到目标端后，目标端复制进程无法启动。
2015-11-01 11:28:51 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT R_IVL starting.
2015-11-01 11:28:51 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT R_IVL restarted automatically.
2015-11-01 11:28:51 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: REPLICAT R_IVL starting.
2015-11-01 11:28:51 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Operating system character set identified as UTF-8. Locale: zh_CN, LC_ALL:.
2015-11-01 11:28:52 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/data/ggs/dirtmp.
2015-11-01 11:28:52 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: REPLICAT R_IVL started.
2015-11-01 11:28:52 ERROR OGG-01091 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Unable to open file "./dirdat/iv000006" (error 2, No such file or directory).
2015-11-01 11:28:52 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: PROCESS ABENDING.
可是目标端为什么会一直报trail文件找不到呢？查看trail文件是存在的。
[oracle@SL010M6-DB-ERPDB1 dirdat]$ ll iv* -rw-rw-rw- 1 oracle oinstall 412422 11月 1 11:34 iv000005 -rw-r--r-- 1 oracle oinstall 34211874 11月 1 11:16 iv000005_20151101 -rw-r--r-- 1 oracle oinstall 27118 11月 1 11:34 iv000006 -rw-r--r-- 1 oracle oinstall 74066 11月 1 11:34 iv000007 -rw-r--r-- 1 oracle oinstall 1444 11月 1 11:34 iv000008 -rw-r--r-- 1 oracle oinstall 99999567 11月 1 11:34 iv000009 -rw-r--r-- 1 oracle oinstall 99999965 11月 1 11:34 iv000010 -rw-r--r-- 1 oracle oinstall 12997603 11月 1 11:34 iv000011 -rw-r--r-- 1 oracle oinstall 21227584 11月 1 11:34 iv000012 -rw-rw-rw- 1 oracle oinstall 3468635 11月 3 10:22 iv000013
iv000005_20151101文件是同事做的备份，iv000005是手动从源端拷贝过来的trail文件。从文件大小上看，两个文件存在很大的差异，很有可能手工拷贝过来的文件也损坏了，查看源端的trail文件发现，源端只有12号trail文件，其他trail文件均消失不见了。
[oracle@SL010A-IVDB01 dirdat]$ ll total 20768 -rw-rw-rw- 1 oracle oinstall 21235931 Nov 1 12:15 iv000012
查看源端的日志发现在11：38分，mrp进程清空了之前的trail文件。
2015-11-01 11:38:20 INFO OGG-00957 Oracle GoldenGate Manager for Oracle, mgr.prm: Purged old extract file /opt/oracle/ggs/dirdat/iv000005, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 12 > 5. 2015-11-01 11:38:20 INFO OGG-00957 Oracle GoldenGate Manager for Oracle, mgr.prm: Purged old extract file /opt/oracle/ggs/dirdat/iv000006, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 12 > 6. 2015-11-01 11:38:20 INFO OGG-00957 Oracle GoldenGate Manager for Oracle, mgr.prm: Purged old extract file /opt/oracle/ggs/dirdat/iv000007, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 12 > 7. 2015-11-01 11:38:20 INFO OGG-00957 Oracle GoldenGate Manager for Oracle, mgr.prm: Purged old extract file /opt/oracle/ggs/dirdat/iv000008, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 12 > 8. 2015-11-01 11:38:20 INFO OGG-00957 Oracle GoldenGate Manager for Oracle, mgr.prm: Purged old extract file /opt/oracle/ggs/dirdat/iv000009, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 12 > 9. 2015-11-01 11:38:20 INFO OGG-00957 Oracle GoldenGate Manager for Oracle, mgr.prm: Purged old extract file /opt/oracle/ggs/dirdat/iv000010, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 12 > 10. 2015-11-01 11:38:20 INFO OGG-00957 Oracle GoldenGate Manager for Oracle, mgr.prm: Purged old extract file /opt/oracle/ggs/dirdat/iv000011, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 12 > 11.
目测目标端5678号trail文件都异常小，应该都存在问题，可是源端已经没有了trail文件，无法对比，经和同事协商，决定源端从10点从新抽取数据，目标端也从10点开始应用。以下是解决过程。
源端先停掉抽取进程。
2015-11-01 12:38:57 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop EXT_IVL. 2015-11-01 12:38:58 INFO OGG-01021 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Command received from GGSCI: STOP. 2015-11-01 12:38:59 INFO OGG-00991 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: EXTRACT EXT_IVL stopped normally.
然后修改源端抽取进程，从10点开始抽取。
2015-11-01 12:40:33 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ALTER EXTRACT EXT_IVL BEGIN 2015-11-01 10:00.
启动源端抽取进程。
2015-11-01 12:42:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start EXT_IVL.
2015-11-01 12:42:00 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host sl010a-ivdb01 (START EXTRACT EXT_IVL ).
2015-11-01 12:42:00 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_IVL starting.
2015-11-01 12:42:00 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: EXTRACT EXT_IVL starting.
2015-11-01 12:42:00 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2015-11-01 12:42:00 WARNING OGG-00254 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: ASMPASSWORD is a deprecated parameter.
2015-11-01 12:42:00 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2015-11-01 12:42:01 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/oracle/ggs/BR/EXT_IVL.
2015-11-01 12:42:01 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/oracle/ggs/dirtmp.
2015-11-01 12:42:02 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Default thread stack size: 10485760.
2015-11-01 12:42:02 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Positioning to begin time Nov 1, 2015 10:00:00 AM.
2015-11-01 12:42:07 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Positioned to (Thread 1) Sequence 9435, RBA 119659520, SCN 0.0, Nov 1, 2015 10:00:00 AM.
2015-11-01 12:42:07 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Positioning to begin time Nov 1, 2015 10:00:00 AM.
2015-11-01 12:42:14 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Positioned to (Thread 2) Sequence 8756, RBA 181077008, SCN 0.0, Nov 1, 2015 10:00:00 AM.
2015-11-01 12:42:14 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Position of first record processed for Thread 1, Sequence 9435, RBA 119659536, SCN 27.1666910956, Nov 1, 2015 10:00:00 AM.
2015-11-01 12:42:14 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Position of first record processed for Thread 2, Sequence 8756, RBA 181077008, SCN 27.1666933201, Nov 1, 2015 10:00:00 AM.
2015-11-01 12:42:14 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: EXTRACT EXT_IVL started.
2015-11-01 12:42:14 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Recovery initialization completed for target file ./dirdat/iv000012, at RBA 21239677.
2015-11-01 12:42:14 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Output file ./dirdat/iv is using format RELEASE 11.2.
2015-11-01 12:42:14 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Rolling over remote file ./dirdat/iv000012.
2015-11-01 12:42:14 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Recovery completed for target file ./dirdat/iv000013, at RBA 1088.
2015-11-01 12:42:14 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ext_ivl.prm: Recovery completed for all targets.
目标端的复制进程此时已经挂掉，就不需要停了，修改目标端复制进程，从10点开始应用。
2015-11-01 12:44:41 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ALTER REPLICAT R_IVL BEGIN 2015-11-01:10:00:00.
启动目标端复制进程。
2015-11-01 12:44:50 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start R_IVL.
2015-11-01 12:44:50 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host sl010m6-db-erpdb1 (START REPLICAT R_IVL ).
2015-11-01 12:44:50 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT R_IVL starting.
2015-11-01 12:44:50 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: REPLICAT R_IVL starting.
2015-11-01 12:44:50 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Operating system character set identified as UTF-8. Locale: zh_CN, LC_ALL:.
2015-11-01 12:44:50 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/data/ggs/dirtmp.
2015-11-01 12:44:50 INFO OGG-01014 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Positioning with begin time: 2015-11-1 上午10:00:00, starting record time: 2015-11-1 上午10:00:01 at extseqno 12, extrba 21206688.
2015-11-01 12:44:50 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: REPLICAT R_IVL started.
目标端复制进程启动后，有一个警告。
2015-11-01 12:44:55 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Repositioning to rba 21207016 in seqno 12. 2015-11-01 12:44:55 INFO OGG-01020 Oracle GoldenGate Delivery for Oracle, r_ivl.prm: Processed extract process RESTART_ABEND record at seq 13, rba 1389 (aborted 0 records).
这是由于目标端指定了从10点开始复制导致的，正常复制进程应该从12号trail文件的21207016偏移量开始复制，由于指定了时间，从13号trail文件的1389偏移量开始复制的，还好由于这套OGG业务量不大，没有遇到错误。以下是启动后的复制进程信息，一切正常。
GGSCI (SL010M6-DB-ERPDB1) 7> stats R_IVL
Sending STATS request to REPLICAT R_IVL ...
Start of Statistics at 2015-11-01 12:45:11.
Replicating from CHGSHS.PRD_UNT_PRD_D to ERPDBER.PRD_UNT_PRD_D:
*** Total statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 60.00
Total deletes 0.00
Total discards 0.00
Total operations 60.00
*** Daily statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 60.00
Total deletes 0.00
Total discards 0.00
Total operations 60.00
*** Hourly statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 60.00
Total deletes 0.00
Total discards 0.00
Total operations 60.00
*** Latest statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 60.00
Total deletes 0.00
Total discards 0.00
Total operations 60.00
Replicating from CHGSHS.GG_HEARTBEAT to ERPDBER.GG_HEARTBEAT:
*** Total statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 324.00
Total deletes 0.00
Total discards 0.00
Total operations 324.00
*** Daily statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 324.00
Total deletes 0.00
Total discards 0.00
Total operations 324.00
*** Hourly statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 324.00
Total deletes 0.00
Total discards 0.00
Total operations 324.00
*** Latest statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 324.00
Total deletes 0.00
Total discards 0.00
Total operations 324.00
Replicating from CHGSHS.FUL_INVC_M to ERPDBER.FUL_INVC_M:
*** Total statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 4.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Daily statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 4.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Hourly statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 4.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Latest statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 4.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
Replicating from CHGSHS.ORD_ORD_DTL_D to ERPDBER.ORD_ORD_DTL_D:
*** Total statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 12.00
Total deletes 0.00
Total discards 0.00
Total operations 12.00
*** Daily statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 12.00
Total deletes 0.00
Total discards 0.00
Total operations 12.00
*** Hourly statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 12.00
Total deletes 0.00
Total discards 0.00
Total operations 12.00
*** Latest statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 12.00
Total deletes 0.00
Total discards 0.00
Total operations 12.00
Replicating from CHGSHS.ORD_ORD_BSC_M to ERPDBER.ORD_ORD_BSC_M:
*** Total statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 2.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
*** Daily statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 2.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
*** Hourly statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 2.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
*** Latest statistics since 2015-11-01 12:44:52 ***
Total inserts 0.00
Total updates 2.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
End of Statistics.
由于网络故障导致OGG trail文件损坏的恢复案例：目前有2 条留言
发表评论
“这是由于目标端指定了从10点开始复制导致的，正常复制进程应该从12号trail文件的21207016偏移量开始负责，由于指定了时间，从13号trail文件的1389偏移量开始复制的”会不会出现主从数据的冲突，有数据不一致的风险？
2015-11-03 13:25有
2015-11-04 10:34好在我们这不是很核心的业务，数据变化不大，通过分析发现，10点多基本没有数据变化，而且参数文件中已经屏蔽掉了ORA-00001错误