Hi,
I got OGG-00446 Could not find archived log for sequence | OGG-01668 PROCESS ABENDING When i check goldengate if it is syncronized or not, I have seen that Goldengate is abended.
OGG-00446 Could not find archived log for sequence
I have checked goldengate like following.
GGSCI (MehmetSalih) 14> info * EXTRACT PUMP01 Last Started 2019-02-28 10:03 Status STOPPED Checkpoint Lag 00:00:00 (updated 00:00:32 ago) Log Read Checkpoint File /u01/Goldengate/dirdat/lt059991 2019-03-19 16:54:47.000000 RBA 8856635 EXTRACT EXT01 Last Started 2019-03-06 20:13 Status ABENDED Checkpoint Lag 00:00:02 (updated 04:56:17 ago) Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:46 Thread 1, Seqno 254559, RBA 84697616 Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:46 Thread 2, Seqno 225018, RBA 101374372
When i check extract report file from EXT01.rpt under /u01/Goldengate/dirrpt directory, I have seen following error.
SourceModule : [er.main] SourceID : [/scratch/angorant/view_storage/angorant_ogg_12978807_x64/oggcore/OpenSys/src/app/er/rep.c] SourceFunction : [extract_start_point] SourceLine : [13018] ThreadBacktrace : [6] elements : [/u01/Goldengate/extract(CMessageContext::AddThreadContext()+0x26) [0x6720a6]] : [/u01/Goldengate/extract(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x668b72]] : [/u01/Goldengate/extract(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x 92) [0x613f92]] : [/u01/Goldengate/extract(main+0x125b) [0x5280ab]] : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3cec01d9c4]] : [/u01/Goldengate/extract(__gxx_personality_v0+0x1ea) [0x4f388a]] 2019-03-19 21:47:36 ERROR OGG-00446 Could not find archived log for sequence 253890 thread 1 under default destinations SQL <SELECT name FROM v$ar chived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'NO>, error retrieving redo file name for sequence 253890, archived = 1, use_alternate = 0Not able to establish initial position for seq uence 253890, rba 8266768.
OGG-01668 PROCESS ABENDING
I have checked related sequence of Archivelog, it exists in the database. If it doesn’t exist, then restore the related archivelogs from backup.
If you don’t know how to restore archivelog from Backup, then read the following article.
Alter Extract Process
If Related archivelog exists and Goldengate still gives same error, then reset Goldengate like following.
GGSCI (MehmetSalih) 15> ALTER EXTRACT EXT01, BEGIN 2019-03-19:16:54:00 EXTRACT altered. GGSCI (MehmetSalih) 16> info EXT01 EXTRACT EXT01 Initialized 2019-03-19 21:51 Status STOPPED Checkpoint Lag 04:57:32 (updated 00:00:04 ago) Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:00 Thread 1, Seqno 0, RBA 0 Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:00 Thread 2, Seqno 0, RBA 0
Start Goldengate Process
Goldengate is reset and I have changed extract process to one minute ago from current time.
Now I have started extract process again like following.
GGSCI (MehmetSalih) 17> start EXT01 Sending START request to MANAGER ... EXTRACT EXT01 starting GGSCI (MehmetSalih) 18> info EXT01 EXTRACT EXT01 Initialized 2019-03-19 21:51 Status RUNNING Checkpoint Lag 04:57:32 (updated 00:00:14 ago) Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:00 Thread 1, Seqno 0, RBA 0 Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:00 Thread 2, Seqno 0, RBA 0 GGSCI (MehmetSalih) 19> ! info EXT01 EXTRACT EXT01 Last Started 2019-03-19 21:52 Status RUNNING Checkpoint Lag 04:58:00 (updated 00:00:01 ago) Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:00 Thread 1, Seqno 254559, RBA 73163792 Log Read Checkpoint Oracle Redo Logs 2019-03-19 16:54:00 Thread 2, Seqno 225018, RBA 90979344 GGSCI (MehmetSalih) 36> ! info * EXTRACT PUMP01 Last Started 2019-03-19 21:53 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:03 ago) Log Read Checkpoint File /u01/Goldengate/dirdat/lt059996 2019-03-19 22:04:10.000000 RBA 11741117 EXTRACT EXT01 Last Started 2019-03-19 21:52 Status RUNNING Checkpoint Lag 00:00:06 (updated 00:00:07 ago) Log Read Checkpoint Oracle Redo Logs 2019-03-19 22:04:04 Thread 1, Seqno 254588, RBA 8173632 Log Read Checkpoint Oracle Redo Logs 2019-03-19 22:04:06 Thread 2, Seqno 225039, RBA 327184 GGSCI (MehmetSalih) 37>
Goldengate has been syncronized like above.
If your problem has not solved even if Archivelog exists in the ASM diskgroup, then add the following TRANLOGOPTIONS option into Parameter file to find Archivelog in the Oracle ASM Diskgroup.
You should create goldengate user in the ASM Instance to be connected.
This is the second case for this error.
TRANLOGOPTIONS ASMUSER goldengate@ASM, ASMPASSWORD goldengate123
When I add the following parameter into Parameter file, my problem has been solved.
Hello there,
My name is Aly. Would you have any interest to have your website here at ittutorial.org promoted as a resource on our blog alychidesign.com ?
We are in the currently updating our do-follow broken link resources to include current and up to date resources for our readers.
If you may be interested please in being included as a resource on our blog, please let me know.
Thanks,
Aly
I needed to thank you for this fantastic read!! I absolutely enjoyed every little bit of it. I have got you book marked to look at new things you post…|
Thank you so much for your nice comments