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

Please follow and like:
Comments
  • 吉田大助「自分が変われば、世界が変わる 作家・第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.

  • 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.

  • 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!

  • 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.

Leave a Reply

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

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.