My Oracle Support Banner

Required_Checkpoint_Scn Not Changing for 11.2 Downstream Capture After Parallel Online Index Rebuilds On Source 10.2 Database (Doc ID 1412928.1)

Last updated on MARCH 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


The required_checkpoint_scn is not moving after parallel online index rebuilds on a 10.2 source are mined by an Downstream Capture.

The job does the following for multiple indexes

alter session force parallel ddl parallel 16;

alter index INDEX_NAME rebuild online;

Ad-hoc LogMiner analysis of the problem transaction indicates redo associated with a PDML_START MARKER

REDO RECORD - Thread:1 RBA: 0x000097.0000c916.002c LEN: 0x0050 VLD: 0x01
SCN: 0x0000.00582f6a SUBSCN: 1 12/21/2011 09:14:18
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ: 0 OP:24.4
xid: 0x0003.004.00000163 ssid: 1 flags 0x0

but no corresponding end marker.


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.