My Oracle Support Banner

How to Configure or Relocate the GoldenGate Integrated Extract When It Abends Error code 1291, error message: ORA-01291: missing logfile (Doc ID 2003603.1)

Last updated on JULY 17, 2018

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 and later
Information in this document applies to any platform.

Goal

 In certain cases, such as the integrated extract is abending with error message:

2015-04-20 10:28:06  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, zilg1e.prm:  Error code 1291, error message: ORA-01291: missing logfile (Missing Log File +FLASHDG/XXXXX/archivelog/2015_04_18/thread_1_seq_110519.288.877390783. Read Position SCN 1324310472). 

In the above situation, customer will have a gap, but it is usually all archives exists on the backup system.

Customers used to restore this archive from the source but it is not in ASM but on a file system e.g. (/u01/app/oracle/archive/XXXX/1_110519_652630774.dbf)

Therefore, the steps detailed in this note will help in  relocating or configuring the GoldenGate integrated extract to look at an alternative location in order to resolve the gap.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.