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 AUGUST 12, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The required_checkpoint_scn is not moving after parallel online index rebuilds on a 10.2 source are mined by an 11.2.0.3 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
Special KRV PDML_START MARKER:
xid: 0x0003.004.00000163 ssid: 1 flags 0x0

but no corresponding end marker.

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