Forum Stats

  • 3,768,013 Users
  • 2,252,740 Discussions
  • 7,874,409 Comments

Discussions

When I started on the ADG ogg, and exttract does not work

User_B3IMP
User_B3IMP Member Posts: 1 Green Ribbon
edited Jun 8, 2021 11:31PM in GoldenGate

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

  • Gururaj0-Oracle
    Gururaj0-Oracle Member Posts: 78 Employee

    Looking at the Extract, I believe you are using Classic extract. Integrated Extract cannot capture from a standby database because it requires READ and WRITE 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