REQUIRED_CHECKPOINT_SCN Not Advancing; Unsafe TXN Datapump Related (Doc ID 751493.1)

Last updated on MAY 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Oracle Database - Enterprise Edition - Version 10.2.0.2 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.

Symptoms

[1] required_checkpoint_scn is not moving forward.
A restart of the Capture process will therefore need to go
back further than desired. This may result in substantial
remining of data which is undesirable. 

additionally,

[2] the Capture process is slow to mine logs.

Related relevant patches applied :
- <bug 5770059> (fixed in 10.2.0.4) and, at the time of the issue the patch for
- bug 6154377.  This fix has subsequently been withdrawn and is superceded by :
<Bug 8267348> (fixed in : 10.2.0.4.1 PSU) ; i.e ensure that this later patch is applied.

Note: there may be merge patches containing the above

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms