Goldengate OGG-01668 PROCESS ABENDING OGG-00446 Could not find OGG-00446 Could not find archived log for sequence

Hi,

When i check goldengate if it is syncronized or not, I have seen that Goldengate is abended.

 

 

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.

 

I have checked related sequence of Archivelog, it exists in the database.

 

 

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

 

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.




  

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

3 thoughts on “Goldengate OGG-01668 PROCESS ABENDING OGG-00446 Could not find OGG-00446 Could not find archived log for sequence

  • April 20, 2019 at 8:44 pm
    Permalink

    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

    Reply
  • May 19, 2019 at 12:09 am
    Permalink

    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…|

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *