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:
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”.
Follow if you like:
Hello there! Do you use Twitter? I’d like to follow you if that
would be ok. I’m definitely enjoying your blog and look forward to
new posts.
Feel free to visit my site :: Eharmony special coupon code 2025
It’s impressive that you are getting thoughts from this post as
well as from our discussion made at this time.
Also visit my web blog :: vpn
Hi! I could have sworn I’ve visited this web site
before but after going through some of the posts I
realized it’s new to me. Regardless, I’m certainly happy I discovered it and I’ll
be book-marking it and checking back regularly! https://tinyurl.com/23ww4xyv gamefly 3 month free trial
Hi there! I know this is kinda off topic but I was wondering which
blog platform are you using for this site?
I’m getting sick and tired of WordPress because I’ve had problems with
hackers and I’m looking at options for another platform.
I would be fantastic if you could point me in the direction of a good platform.
https://tinyurl.com/2ax86k6l what does a vpn do
When I originally commented I clicked the “Notify me when new comments are added” checkbox and now
each time a comment is added I get several e-mails with the same
comment. Is there any way you can remove people from that service?
Many thanks!
Awesome website you have here but I was wondering if you
knew of any discussion boards that cover the same topics discussed
in this article? I’d really love to be a part of group where I can get suggestions from other knowledgeable individuals that share the same interest.
If you have any recommendations, please let me know. Many thanks!