Required_Checkpoint_Scn Not Changing for 11.2 Downstream Capture After Parallel Online Index Rebuilds On Source 10.2 Database
Last updated on AUGUST 12, 2014
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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 126.96.36.199 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.
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