1、停止数据库,抽取进程abbend
2014-09-13 11:47:54 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ext_app.prm: OCI Error executing single row select (status = 3135-ORA-03135: connection lost contact
Process ID: 15947
Session ID: 34 Serial number: 1353), SQLv$logfile lf, v$log l WHERE lf.group# = l.group# AND l.thread# = :ora_thread AND l.sequence# = :ora_seq_no AND (lf.status NOT IN ('INVALID','INCOMPLETE','STALE') OR lf.status is null) order by lf.member DESC ) where rownum = 1>.
2014-09-13 11:47:55 INFO OGG-00991 Oracle GoldenGate Capture for Oracle, ext_app.prm: EXTRACT EXT_APP stopped normally.
2014-09-13 11:50:38 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_APP starting.
2014-09-13 11:50:38 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_APP restarted automatically.
2014-09-13 11:50:38 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext_app.prm: EXTRACT EXT_APP starting.
2014-09-13 11:50:38 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext_app.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2014-09-13 11:50:38 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, ext_app.prm: OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory).
2014-09-13 11:50:38 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext_app.prm: PROCESS ABENDING.
2、startup数据库,抽取进程自动重启running:
2014-09-13 11:53:40 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, ext_app.prm: No valid default archive log destination directory found for thread 2.
2014-09-13 11:53:40 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, ext_app.prm: Default thread stack size: 10485760.
2014-09-13 11:53:40 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext_app.prm: Positioning to (Thread 1) Sequence 85, RBA 9232, SCN 0.1857793.
2014-09-13 11:53:41 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext_app.prm: Positioned to (Thread 1) Sequence 85, RBA 9232, SCN 0.1857793, Sep 13, 2014 11:47:46 AM.
2014-09-13 11:53:41 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext_app.prm: Positioning to begin time Sep 13, 2014 11:37:18 AM.
2014-09-13 11:53:41 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext_app.prm: Position of first record processed for Thread 1, Sequence 85, RBA 9232, SCN 0.1857793, Sep 13, 2014 11:47:46 AM.
2014-09-13 11:53:41 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext_app.prm: EXTRACT EXT_APP started.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27126919/viewspace-1305611/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27126919/viewspace-1305611/