当前位置: 首页 > GoldenGate, oracle 11g > 正文

由于网络故障导致OGG trail文件损坏的恢复案例

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.

 

本文固定链接: http://www.dbdream.com.cn/2015/11/%e7%94%b1%e4%ba%8e%e7%bd%91%e7%bb%9c%e6%95%85%e9%9a%9c%e5%af%bc%e8%87%b4ogg-trail%e6%96%87%e4%bb%b6%e6%8d%9f%e5%9d%8f%e7%9a%84%e6%81%a2%e5%a4%8d%e6%a1%88%e4%be%8b/ | 信春哥,系统稳,闭眼上线不回滚!

该日志由 dbdream 于2015年11月03日发表在 GoldenGate, oracle 11g 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: 由于网络故障导致OGG trail文件损坏的恢复案例 | 信春哥,系统稳,闭眼上线不回滚!
关键字: , , , ,

由于网络故障导致OGG trail文件损坏的恢复案例:目前有2 条留言

  1. 沙发
    王亮:

    “这是由于目标端指定了从10点开始复制导致的,正常复制进程应该从12号trail文件的21207016偏移量开始负责,由于指定了时间,从13号trail文件的1389偏移量开始复制的”会不会出现主从数据的冲突,有数据不一致的风险?

    2015-11-03 13:25 [回复]

    • 好在我们这不是很核心的业务,数据变化不大,通过分析发现,10点多基本没有数据变化,而且参数文件中已经屏蔽掉了ORA-00001错误

      2015-11-04 10:34 [回复]

发表评论

快捷键:Ctrl+Enter