Hello，everyone，I have a question. My source environment is aix rac system. There is a dataguard to synchronize rac data. Now I want to synchronize data from the dg side to the mysql database under linux. When the dg side starts the ogg extraction process, the process does not work. Always prompt: EXTRACT EXT1 is initializing, please try the command later.
GGSCI (zjdb01) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 01:46:56
GGSCI (zjdb01) 2> stop ext1
ERROR: EXTRACT EXT1 is initializing, please try the command later.
the ggserr message info:
2021-06-08 14:57:53 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, ext1.prm: Successfully set environment variable ORACLE_SID=orcldg.
2021-06-08 14:57:54 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone '+08:00'.
2021-06-08 14:57:54 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2021-06-08 14:57:54 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/ogg_data/BR/EXT1.
2021-06-08 14:57:54 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 1286.
2021-06-08 14:57:54 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/ogg_data/dirtmp.
2021-06-08 14:57:55 WARNING OGG-02810 Oracle GoldenGate Capture for Oracle, ext1.prm: A relative timestamp, such as NOW, was used as starting position for Extract on an Oracle Active Data Guard standby database.
2021-06-08 14:57:55 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 11.2.0.4.0.
2021-06-08 14:57:55 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, ext1.prm: Default thread stack size: 196608.
2021-06-08 14:57:55 INFO OGG-00547 Oracle GoldenGate Capture for Oracle, ext1.prm: Increasing thread stack size from 196608 to 1048576.
2021-06-08 14:57:55 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to begin time 2021 M06 8 14:57:46.
2021-06-08 14:57:56 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
the parameter info:
add extract ext1,tranlog,begin now,THREADS 2
add exttrail ./dirdat/le,extract ext1,megabytes 500
extract ext1
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
SETENV (ORACLE_SID=orcldg)
userid goldengate@orcldg,password password
TRANLOGOPTIONS MINEFROMACTIVEDG
discardfile ./dirrpt/dce1.dsc,append
exttrail ./dirdat/le
statoptions reportfetch
reportcount every 1 minutes,rate
warnlongtrans 1H,checkinterval 5m
table business.test;