My Oracle Support Banner

Goldengate Log Retention Don`t Work After Upgrade DB From 10g To 11g (Doc ID 1917999.1)

Last updated on JULY 22, 2015

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


Log retention used in goldengate classic capture mode used by registering extract, a underlying capture process was created.

In 10g the REQUIRED_CHECKPOINT_SCN will move after GG checkpoint operation. Then decide which archived log can be purged with RMAN.

Upgraded DB from 10g to 11g the REQUIRED_CHECKPOINT_SCN become to 0 and never change. RMAN cannot delete the archived log.

After upgrade to 11g “register extract logretention” doesn’t work as it was in 10g.


Database upgrade from 10g to 11g


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.