Classic Extract Abends With Error RAC Doesn't Support Parallel Direct Load Of Table when CTAS

(Doc ID 2290368.1)

Last updated on AUGUST 23, 2017

Applies to:

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

Symptoms

Classic Extract not supports CTAS in a Bi-Directional Replication.

For example, below is the example with a 2 Node RAC.


From site1 (source) triggered following sql statements: create table supplier, insert, update, delete and it was successfully replicated to site2 (targert)

Next from site2 (source) triggered following sql statements: : insert into supplier, create table gg_ddl_test as select * from supplier and it got replicated to site1.

Then from site1 triggered: insert or truncate of table gg_ddl_test causes extract to abend with OGG_1875 error

2017-04-25 11:17:50 INFO OGG-01517 Position of first record processed for Thread 2, Sequence 2897, RBA 1335247888, SCN 0.99240734 (99240734), Apr 24, 2017 10:20:30 AM.

Source Context :
  SourceModule : [er.redo.ora.sr]
  SourceID : [/scratch/debassah/view_storage/debassah_solarisx64fbo/oggcore/OpenSys/src/app/er/redo/oracle/redoorasr.c]
  SourceFunction : [get_direct_load_insvals]
  SourceLine : [5487]

2017-04-25 11:17:50 ERROR OGG-01875 Classic Extract doesn't support RAC parallel direct load of table.

2017-04-25 11:17:50 INFO OGG-01055 Recovery initialization completed for target file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt000005172, at RBA 1448.

2017-04-25 11:17:50 INFO OGG-01478 Output file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt is using format RELEASE 12.2.

2017-04-25 11:17:50 INFO OGG-01026 Rolling over remote file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt000005172.

2017-04-25 11:17:50 INFO OGG-01053 Recovery completed for target file /oraswgg/app/OGG/dirdat/ntrs1/ext/lt000005173, at RBA 1448.

2017-04-25 11:17:50 INFO OGG-01057 Recovery completed for all targets.

 

There is no parallel load performed in the database, but still the Extract process abends with the below error when a CTAS is performed.,

ERROR OGG-01875 Classic Extract doesn't support RAC parallel direct load of table.

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