Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
When I started on the ADG ogg, and exttract does not work

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 [email protected],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;
Answers
-
Looking at the Extract, I believe you are using Classic extract. Integrated Extract cannot capture from a standby database because it requires
READ
andWRITE
access.This "initializing" message means that Extract is unable to mine redo logs and fetch from it using standard connection information supplied using the
USERID
parameter.So, check the connection, DB parameters related to red logs settings and see if they are all valid.
Regards
Gururaj