OGG Extract abends with OGG-01028 Record position is beyond end of recovery [ID 1335470.1]

Posted: 十月 12, 2011 in bugs
OGG Extract abends with OGG-01028 Record position is beyond end of recovery [ID 1335470.1]

Modified 07-OCT-2011 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution
References


 

 

Applies to:

Oracle GoldenGate – Version: 11.1.1.1.0 and later [Release: 11.1.1 and later ]
Information in this document applies to any platform.

Symptoms

Extract abends with below error:

ERROR OGG-01028 Record position (SeqNo: 336, RBA: 1040, SCN: 0.40418944 (40418944)) is beyond end of recovery (SeqNo: 335, RBA: 9016952, SCN: 0.40255602 (40255602), Timestamp: 2011-06-21 10:57:03.000000).

Cause

Extract may have hit bug which can occur while processing a 0-length record while the extract is enabled for Bounded Recovery.

Solution

As a work around , please use the below extract parameter and start the extract which will turn off the Bounded recovery. When BR is off, the Extract will do a normal recovery, so it needs all the archive logs file starting from recovery checkpoint of the extract.

BR BROFF

The only time BR is used is upon restart of extract, and only if there were any long running transactions that were persisted. If all of the transactions in the workload are of short duration (less than the BR interval default of 4 hrs), then even upon restart, standard recovery is active instead of bounded recovery.

And regarding transactions we are only concerned with ones that modify data. There may, of course, be batch jobs which run and take a long time, so these could fall into the long duration category thats mentioned above, but even in this case, as long as the redo logs/archive logs are available for standard recovery, the restart time should not be much longer with SR (standard recovery) than BR.

Once the extract has passed by the problematic RBA, this parameter can be removed.The permanent fix is planned for OGG v11.2.1.

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s