OGG-00868/ORA-01291 – Missing log files with Integrated Extract
Oracle GoldenGate is reliant on the Oracle Redo Logs and Archive Logs when capturing transactions. Since I do a lot of testing on VMs (limited space) and in the cloud (limited space … don’t want to burn to much $), I often delete my archive logs. Normally this is not a problem; however, every once-in-awhile I delete more archivelogs than I should. This throws the IE into a state where it will not start because of OGG-00868/ORA-01291 – Missing Log Files.
On some level this is to be expected, but when you are using IE you have to remember that the extract is registered with the database. Since I’m using Integrated Extract, we have to reset how the extract is registered with the database. The below steps will show you how this should be done:
Note: Registering/Unregistering process have to be done at the container database (CDB) level.
adminclient> dblogin useridalias <alias> domain <domain>
adminclient> stop extract <extract_name>
adminclient> unregister extract <extract_name> database
adminclient> register extract <extract_name> database container <container_name>
adminclient> start extract <extract_name>
adminclient> info extract <extract_name>
Once the extract is re-registered with the database; the integrated extract will start.
Enjoy!!!
Current Oracle Certs

Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.

Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
吉田大助「自分が変われば、世界が変わる 作家・第22回FNSドキュメンタリー大賞作品 「負げねど!立教大学新聞第148号(1957年11月8日)にある、アーサー・ 2024年11月15日閲覧。 2024年11月16日閲覧。 OECD東北スクール.2015年3月11日閲覧。 「震災の教訓と再起、後世に伝える 遺構「旧女川交番」完成」『河北新報』2020年3月4日。
Right here is the right web site for anybody who wishes to find out about this topic. You know a whole lot its almost hard to argue with you (not that I actually will need to…HaHa). You certainly put a new spin on a subject that has been written about for many years. Wonderful stuff, just excellent.
17 (17): 2437-2450. doi:10.1039/B103147N.
Missing funds on your QIWI wallet?We know how stressful that can be.Don’t despair—our team specializes in retrieving lost funds from QIWI wallets.Boasting years of experience, we’re sure we can assist you.Reach out to us and let’s get to work of recoveringyour funds.
Your article helped me a lot, is there any more related content? Thanks!
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
you’re really a good webmaster. The site loading speed is incredible. It seems that you’re doing any unique trick. Furthermore, The contents are masterpiece. you have done a magnificent job on this topic!
Great post, I conceive blog owners should larn a lot from this web site its real user pleasant.
It’s truly a nice and helpful piece of info. I’m glad that you just shared this useful information with us. Please stay us up to date like this. Thank you for sharing.