RLYSI_B进程 ABENDING
view report 报ERROR OGG-00446 .
GGSCI (juece2) 2> view report RLYSI_B
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Apr 23 2012 07:01:27
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2019-07-18 13:18:41
***********************************************************************Operating System Version:
AIX
Version 6, Release 1
Node: juece2
Machine: 00F90A954C00
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimitedProcess id: 4981290
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************2019-07-18 13:18:41 INFO OGG-03035 Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
REPLICAT rlysi_b。。。。
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"Source Context :
SourceModule : [er.common]
SourceID : [/scratch/aime1/adestore/views/aime1_staxk12/oggcore/OpenSys/src/app/er/common.cpp]
SourceFunction : [extract_start_point(time_elt_def *, time_elt_def *)]
SourceLine : [2090]2019-07-18 13:18:46 ERROR OGG-00446 .
2019-07-18 13:18:46 ERROR OGG-01668 PROCESS ABENDING.
查看ggserr.log
2019-07-18 10:06:07 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host juece2 (START REPLICAT RLYSI_B ).
2019-07-18 10:06:07 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RLYSI_B starting.
2019-07-18 10:06:08 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rlysi_b.prm: REPLICAT RLYSI_B starting.
2019-07-18 10:06:08 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rlysi_b.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
2019-07-18 10:06:10 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, rlysi_b.prm: SQL statement executed successfully.
2019-07-18 10:06:10 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rlysi_b.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/back/ogg/dirtmp.
2019-07-18 10:06:15 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rlysi_b.prm: .
2019-07-18 10:06:15 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rlysi_b.prm: PROCESS ABENDING.
2019-07-18 10:11:22 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing ./dirdat/el007957 to disk.
2019-07-18 10:11:22 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing ./dirdat/el007957 to disk.
2019-07-18 10:11:22 INFO OGG-01670 Oracle GoldenGate Collector for Oracle: Closing ./dirdat/el007957.
2019-07-18 10:11:22 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening ./dirdat/el007958 (byte -1, current EOF 0).
查看进程状态
GGSCI (juece2) 2> info RLYSI_B
REPLICAT RLYSI_B Last Started 2019-07-18 16:54 Status ABENDED
Checkpoint Lag 186:15:05 (updated 237:51:09 ago)
Log Read Checkpoint File ./dirdat/el007849
2019-07-01 01:07:00.478627 RBA 429720222
alter RLYSI_B extseqno 7849 extrba 429720222
GGSCI (juece2) 4> alter RLYSI_B extseqno 7849 extrba 429720222;
REPLICAT altered.
查看所有进程状态
GGSCI (juece2) 5> info allProgram Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED RLYSI_B 00:00:00 00:00:17
REPLICAT RUNNING RLYSI_S 00:00:00 00:00:01
REPLICAT RUNNING R_OTHER 00:00:00 00:00:02
启动进程
GGSCI (juece2) 6> start RLYSI_BSending START request to MANAGER ...
REPLICAT RLYSI_B starting
GGSCI (juece2) 7> info allProgram Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RLYSI_B 424:12:42 00:00:01
REPLICAT RUNNING RLYSI_S 00:00:00 00:00:04
REPLICAT RUNNING R_OTHER 00:00:00 00:00:04