Skip to Main Content
  • Questions
  • OGG-00446 Oracle GoldenGate Capture for Oracle, ext1.prm: Could not find archived log for sequence 17

Breadcrumb

May 4th

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

Comments

Sam Mathews, October 02, 2016 - 12:27 pm UTC

Due to some reasons, there is a scheduled job on source database which performs the backup of source database in every 5 hours and deletes the archived logs which can not be changed. Is there any other solution?
Connor McDonald
October 03, 2016 - 12:02 am UTC

"Due to some reasons" is tyically the phrase used by DBA's when they dont want to change their processes :-)

Because "which can not be changed" is of course fiction. It's not like we ship the database to you with an delete-5hrs process built in :-)

The problem is pretty simple - you want resource "X", and someone else is deleting resource "X" before you used it.

Why archivelogs are need for extract process.

vinodh, May 25, 2017 - 3:28 pm UTC

Hi As the gg extract process looking for transaction from redo logs why archive logs are need ?

Is it due to long running transaction?

Thanks,
Vinodh G R
Bobby Curtis
May 30, 2017 - 1:40 pm UTC

Thanks for asking.

Oracle GoldenGate will read the redo logs to capture data for committed transactions. The archive logs are needed for various reasons, but the three most common are:

1. Long running transaction
2. The capture process has been stopped and the SCN has moved into the archive logs, upon recovery or restart
3. The capture process has been setup as a mining server, which requires archive logs.

When you see the error:

"OGG-00446 Oracle Golden Gate Capture for Oracle, ext1.prm: Could not find archived log for sequence xx"

This is due to one of two reasons:

1. The stopping point of the capture process moving into archive logs and the required archive log is missing
2. On restart/recovery of the capture process the archive log is not available due to an RMAN backup or access to the directory where archive logs are is not available.



More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.