Skip to Main Content

Breadcrumb

Warning

Before you submit your comment...

Remember - this is about feedback to the original question. AskTOM is about building a strong Oracle community, not stealing time away from others needing assistance by sneaking in a brand new question under the guise of "Comment".

If your comment requires a response that might include a query, please supply very simple CREATE TABLE and INSERT statements. Nice simple scripts so we can replicate your issue simply.

Remember to take a look at Legal Notices and Terms of Use before supplying a comment...

Don't forget, your comments are public. If you want to send a comment to just the AskTOM team, please use the feedback option

Comment

Highlight any SQL, PL/SQL, or fixed-width text and click the <code> button
 (will never be published or used to spam you)

Question and Answer

Bobby Curtis

Thanks for the question, Sam.

Asked: October 02, 2016 - 8:20 am UTC

Last updated: May 30, 2017 - 1:40 pm UTC

Version: 11g

Viewed 10K+ times! This question is

You Asked

Hi,
This query is related to Golden Gate version 11.2
Source Database : Oracle 11gR2
Target Database : Oracle11gR2

I have configured the golden gate on source and target.
Initial Load worked properly but extract process stopped showing error
OGG-00446 Oracle Golden Gate Capture for Oracle, ext1.prm: Could not find archived log for sequence xx

The reason behind is, on source database, they take backup on every 5 hours and delete the archived logs till the backup. Now extract process is showing this error it could not found the archived log for sequence xx.

What could be the solution for this.

and Connor said...

The solution seems fairly straightforward to me - dont delete archivelogs until they have been used by everything that needs them (including Goldengate).

From 11.2, RMAN and Goldengate have some integration, so consider using RMAN to determine which archivelogs can be deleted.

A blog post related to that here

http://oradbatips.blogspot.com.au/2012/09/tip-101-goldengate-and-archivelog.html

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment