In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Tuesday, December 18, 2018

ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, XXXX.prm: No valid log files for current redo sequence X, thread X, error retrieving redo file name for sequence X, archived = 0, use_alternate = 0Not able to establish initial position for begin time

While starting goldengate extract process, extract PROCESS ABENDING with below error message. It was due to filesytem mismatch, goldengate extract process was unable to extract data from file. I have created archive log destination in ASM storage. To overcome below error message we need to use TRANLOGOPTIONS and DBLOGREADER in extract parameter file.

ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, ex1.prm:  No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2018-12-18 00:44:48.000000.

sample extract parameter file after modification:-
EXTRACT ex1
USERID gguser PASSWORD gguser
DISCARDFILE /home/oracle/gghome/dirrpt/ex1.dsc, APPEND, MEGABYTES 50
EXTTRAIL /home/oracle/gghome/dirdat/ex

TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 4194304
TRANLOGOPTIONS BUFSIZE 10000000
TABLE us01.*;
PARAMETERDESCRIPTION

TRANLOGOPTIONSSpecific directives while mining transactions
DBLOGREADERNew ASM API to extract data
BUFSIZEMax bytes of memory allocated to read redo data – Increases Capture Speed
DBLOGREADERBUFSIZEIncreases Maximum read size for ASM

 after added parameters TRANLOGOPTIONS and DBLOGREADER in extract parameter file, the issue resolved.

GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start ex1.
2018-12-18T00:59:37.330+0530  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [192.168.56.101]:38938 (START EXTRACT EX1 ).
2018-12-18T00:59:37.330+0530  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EX1 starting.
2018-12-18T00:59:37.502+0530  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, ex1.prm:  EXTRACT EX1 starting.
2018-12-18T00:59:37.505+0530  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, ex1.prm:  Operating system character set identified as UTF-8.
2018-12-18T00:59:37.505+0530  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, ex1.prm:  ANSI SQL parameter syntax is used for parameter parsing.
2018-12-18T00:59:38.349+0530  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, ex1.prm:  Setting session time zone to source database time zone 'GMT'.
2018-12-18T00:59:38.436+0530  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, ex1.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.
2018-12-18T00:59:38.460+0530  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, ex1.prm:  Virtual Memory Facilities for: BR
                                  anon alloc: mmap(MAP_ANON)  anon free: munmap
                                  file alloc: mmap(MAP_SHARED)  file free: munmap
                                  target directories:
                                  /home/oracle/gghome/BR/EX1.
2018-12-18T00:59:38.460+0530  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, ex1.prm:  filecaching started: thread ID: 140188920772352.
2018-12-18T00:59:38.474+0530  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, ex1.prm:  Virtual Memory Facilities for: COM
                                  anon alloc: mmap(MAP_ANON)  anon free: munmap
                                  file alloc: mmap(MAP_SHARED)  file free: munmap
                                  target directories:
                                  /home/oracle/gghome/dirtmp.
2018-12-18T00:59:38.574+0530  INFO    OGG-06604  Oracle GoldenGate Capture for Oracle, ex1.prm:  Database GGTEST1 CPU info: CPU Count 1, CPU Core Count 0, CPU Socket Count 0.
2018-12-18T00:59:38.731+0530  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, ex1.prm:  Setting session time zone to source database time zone 'GMT'.
2018-12-18T00:59:38.886+0530  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, ex1.prm:  Source redo compatibility version is: 12.1.0.2.0.
2018-12-18T00:59:38.886+0530  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, ex1.prm:  Positioning to begin time 2018 M12 18 00:52:05.
2018-12-18T00:59:40.435+0530  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, ex1.prm:  Positioned to Sequence 8, RBA 25189904, SCN 0.0 (0), 2018 M12 18 00:52:05.
2018-12-18T00:59:40.435+0530  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, ex1.prm:  EXTRACT EX1 started.
2018-12-18T00:59:40.435+0530  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, ex1.prm:  No recovery is required for target file /home/oracle/gghome/dirdat/ex000000000, at RBA 0 (file not opened).
2018-12-18T00:59:40.435+0530  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, ex1.prm:  Output file /home/oracle/gghome/dirdat/ex is using format RELEASE 12.3.
2018-12-18T00:59:40.435+0530  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, ex1.prm:  Position of first record processed Sequence 8, RBA 25189904, SCN 0.1849786 (1849786), 2018 M12 18 00:52:05.

hope, this helps.

No comments:

free counters
 
Share/Bookmark