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:-
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.
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.*;
PARAMETER | DESCRIPTION |
---|---|
TRANLOGOPTIONS | Specific directives while mining transactions |
DBLOGREADER | New ASM API to extract data |
BUFSIZE | Max bytes of memory allocated to read redo data – Increases Capture Speed |
DBLOGREADERBUFSIZE | Increases Maximum read size for ASM |
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.
No comments:
Post a Comment