OGG-01668: PROCESS ABENDING:添加DataPump进程时的一个错误
来源:互联网 发布:淘宝人生 编辑:程序博客网 时间:2024/06/08 16:25
这种情况发生在,先使用EXTRACT不使用数据泵直接同步数据到目标库,进行一些DML操作后,
再添加DataPump进程,此时重新启动PUMP和EXTRACT进程后,EXTRACT挂起。
GGSCI (bys001.oel.com) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:01
EXTRACT ABENDED EXT3 00:00:00 00:08:29
EXTRACT RUNNING PUMP3 00:00:00 00:00:09
REPLICAT RUNNING REP2 00:00:00 00:00:02
GGSCI (bys001.oel.com) 3> exit
[oracle@bys001 ogg]$ tail -n 50 ggserr.log
2013-08-29 19:36:17 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext3.prm: EXTRACT EXT3 started.
2013-08-29 19:36:17 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, ext3.prm:Failed to open target trail file /u01/ogg/dirdat/bt000000, at RBA 1271. ----无法锁定文件
2013-08-29 19:36:17 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext3.prm:PROCESS ABENDING. -----进程挂起
############################
从目标库上将 /u01/ogg/dirdat/bt*复制到主库,
[oracle@bys2 dirdat]$ scp bt00000* 192.168.1.211:/u01/ogg/dirdat/
重新启动PUMP和EXTRACT进程后状态及日志:
[oracle@bys001 ogg]$ cd dirdat
[oracle@bys001 dirdat]$ ls -al bt00000*
-rw-r--r-- 1 oracle oinstall 1271 Aug 29 19:42 bt000000
-rw-r--r-- 1 oracle oinstall 1429 Aug 29 19:42 bt000001
[oracle@bys001 dirdat]$ cd ..
[oracle@bys001 ogg]$ ./ggsci
GGSCI (bys001.oel.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:09
EXTRACT ABENDED EXT3 00:00:00 00:10:32
EXTRACT RUNNING PUMP3 00:00:00 00:00:01
REPLICAT RUNNING REP2 00:00:00 00:00:08
GGSCI (bys001.oel.com) 2> start ext3
Sending START request to MANAGER ...
EXTRACT EXT3 starting
GGSCI (bys001.oel.com) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:05
EXTRACT RUNNING EXT3 00:10:53 00:00:01
EXTRACT RUNNING PUMP3 00:00:00 00:00:08
REPLICAT RUNNING REP2 00:00:00 00:00:05
日志:
2013-08-29 19:42:10 INFO OGG-01054 Oracle GoldenGate Capture for Oracle, pump3.prm: Recovery completed for target file /u01/ogg/dirdat/bt000001, at RBA 1429, CSN 1357929.
2013-08-29 19:42:10 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, pump3.prm: Recovery completed for all targets.
2013-08-29 19:43:09 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext3.
2013-08-29 19:43:09 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host bys001.oel.com (START EXTRACT EXT3 ).
2013-08-29 19:43:09 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT3 starting.
2013-08-29 19:43:09 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext3.prm: EXTRACT EXT3 starting.
2013-08-29 19:43:09 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext3.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2013-08-29 19:43:09 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, ext3.prm: WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of AL32UTF8.
2013-08-29 19:43:09 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext3.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT3.
2013-08-29 19:43:09 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext3.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
2013-08-29 19:43:10 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext3.prm: Positioning to Sequence 30, RBA 28416528, SCN 0.1364598.
2013-08-29 19:43:10 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext3.prm: Positioned to Sequence 30, RBA 28416528, SCN 0.1364598, Aug 29, 2013 7:32:11 PM.
2013-08-29 19:43:10 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext3.prm: EXTRACT EXT3 started.
2013-08-29 19:43:10 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, ext3.prm:Recovery initialization completed for target file /u01/ogg/dirdat/bt000001, at RBA 1429, CSN 1357929.
2013-08-29 19:43:10 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext3.prm: Output file /u01/ogg/dirdat/bt is using format RELEASE 11.2.
2013-08-29 19:43:10 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext3.prm: Rolling over remote file /u01/ogg/dirdat/bt000001.
2013-08-29 19:43:10 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext3.prm: Position of first record processed Sequence 30, RBA 28416528, SCN 0.1364598, Aug 29, 2013 7:32:11 PM.
再添加DataPump进程,此时重新启动PUMP和EXTRACT进程后,EXTRACT挂起。
GGSCI (bys001.oel.com) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:01
EXTRACT ABENDED EXT3 00:00:00 00:08:29
EXTRACT RUNNING PUMP3 00:00:00 00:00:09
REPLICAT RUNNING REP2 00:00:00 00:00:02
GGSCI (bys001.oel.com) 3> exit
[oracle@bys001 ogg]$ tail -n 50 ggserr.log
2013-08-29 19:36:17 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext3.prm: EXTRACT EXT3 started.
2013-08-29 19:36:17 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, ext3.prm:Failed to open target trail file /u01/ogg/dirdat/bt000000, at RBA 1271. ----无法锁定文件
2013-08-29 19:36:17 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext3.prm:PROCESS ABENDING. -----进程挂起
############################
从目标库上将 /u01/ogg/dirdat/bt*复制到主库,
[oracle@bys2 dirdat]$ scp bt00000* 192.168.1.211:/u01/ogg/dirdat/
重新启动PUMP和EXTRACT进程后状态及日志:
[oracle@bys001 ogg]$ cd dirdat
[oracle@bys001 dirdat]$ ls -al bt00000*
-rw-r--r-- 1 oracle oinstall 1271 Aug 29 19:42 bt000000
-rw-r--r-- 1 oracle oinstall 1429 Aug 29 19:42 bt000001
[oracle@bys001 dirdat]$ cd ..
[oracle@bys001 ogg]$ ./ggsci
GGSCI (bys001.oel.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:09
EXTRACT ABENDED EXT3 00:00:00 00:10:32
EXTRACT RUNNING PUMP3 00:00:00 00:00:01
REPLICAT RUNNING REP2 00:00:00 00:00:08
GGSCI (bys001.oel.com) 2> start ext3
Sending START request to MANAGER ...
EXTRACT EXT3 starting
GGSCI (bys001.oel.com) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:05
EXTRACT RUNNING EXT3 00:10:53 00:00:01
EXTRACT RUNNING PUMP3 00:00:00 00:00:08
REPLICAT RUNNING REP2 00:00:00 00:00:05
日志:
2013-08-29 19:42:10 INFO OGG-01054 Oracle GoldenGate Capture for Oracle, pump3.prm: Recovery completed for target file /u01/ogg/dirdat/bt000001, at RBA 1429, CSN 1357929.
2013-08-29 19:42:10 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, pump3.prm: Recovery completed for all targets.
2013-08-29 19:43:09 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext3.
2013-08-29 19:43:09 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host bys001.oel.com (START EXTRACT EXT3 ).
2013-08-29 19:43:09 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT3 starting.
2013-08-29 19:43:09 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext3.prm: EXTRACT EXT3 starting.
2013-08-29 19:43:09 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext3.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2013-08-29 19:43:09 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, ext3.prm: WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of AL32UTF8.
2013-08-29 19:43:09 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext3.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT3.
2013-08-29 19:43:09 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext3.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
2013-08-29 19:43:10 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext3.prm: Positioning to Sequence 30, RBA 28416528, SCN 0.1364598.
2013-08-29 19:43:10 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext3.prm: Positioned to Sequence 30, RBA 28416528, SCN 0.1364598, Aug 29, 2013 7:32:11 PM.
2013-08-29 19:43:10 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext3.prm: EXTRACT EXT3 started.
2013-08-29 19:43:10 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, ext3.prm:Recovery initialization completed for target file /u01/ogg/dirdat/bt000001, at RBA 1429, CSN 1357929.
2013-08-29 19:43:10 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext3.prm: Output file /u01/ogg/dirdat/bt is using format RELEASE 11.2.
2013-08-29 19:43:10 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext3.prm: Rolling over remote file /u01/ogg/dirdat/bt000001.
2013-08-29 19:43:10 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext3.prm: Position of first record processed Sequence 30, RBA 28416528, SCN 0.1364598, Aug 29, 2013 7:32:11 PM.
- OGG-01668: PROCESS ABENDING:添加DataPump进程时的一个错误
- 揭示OGG DataPump进程和Server进程运行原理的几篇文章
- OGG-01031 由于网络中断导致datapump进程ABENDED的恢复方法
- 第八章:ogg初始化datapump
- 第八章:ogg初始化datapump
- 数据库迁移时Excel列格式错误导致数据丢失的问题-Oracle-Datapump
- Oracle-OGG trail 文件大小引起的进程异常 OGG-01172
- Oracle goldengate的OGG-01004 OGG-1296错误
- Oracle goldengate的OGG-01004 OGG-1296错误
- Process进程的操作
- Process进程的了解
- nodejs的进程process
- 查看ogg目的端的server进程
- mysql-oracle无pump进程的ogg
- GoldenGate投递进程OGG-01416+OGG-01061错误处理一例
- 关于一个应用进程打开另外一个应用进程的TASK和PROCESS 说明
- Oracle Goldengate For Mysql 复制进程错误ERROR OGG-00768
- python:Process、join()、进程的创建Process子类、进程池Pool、将一个文件夹的内容copy到另一个文件夹
- Android ADB 完美支持中文 详细讲解(三)
- 线程安全的servlet
- Eclipse开发Android程序引入第三方jar包的方法
- 图像相似度计算
- 浅谈android的selector背景选择器
- OGG-01668: PROCESS ABENDING:添加DataPump进程时的一个错误
- jstl fmt:formatdate转载
- java反射案例详解
- iOS 打开设备相册
- iOS推送消息 php做推送服务端
- c++文件I/O(781-788)
- [MySQL] innobackupex在线备份及恢复(全量和增量)
- 数据结构上机题目1--基本排序
- SQL Server 相关站点