Forum Discussion

Steve Thompson's avatar
Steve Thompson
Copper Contributor
Mar 27, 2018

Change Data Capture for Oracle by Attunity

Hi,
a client is attempting to utilise ‘Change Data Capture for Oracle by Attunity‘ as provided in the SQL Server 2016 feature pack. This has been proven in a test environment using a Primary Oracle database but the production requirement is to captuire changes from a standby database (managed by Oracle Data Guard). This has so far been unsuccessful - see log below.
My question is:


Does Change Data Capture for Oracle by Attunity support CDC from an Oracle standby database (logical, physical or both) and if so where can I find relevant configuration details?
Cheers,


Steve


“3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Adding redo logs to log miner session.","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u03/oradata/erplnd3/redoa/erplnd3_redo03a.dbf, Sequence: 843","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u03/oradata/erplnd3/redob/erplnd3_redo03b.dbf, Sequence: 843","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u03/oradata/erplnd3/redoc/erplnd3_redo03c.dbf, Sequence: 843","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_13/o1_mf_1_842_fbhnpy3x_.arc, Sequence: 842","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_13/o1_mf_1_841_fbh8641z_.arc, Sequence: 841","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_13/o1_mf_1_840_fbgtsk65_.arc, Sequence: 840","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_13/o1_mf_1_839_fbgfjmx2_.arc, Sequence: 839","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_12/o1_mf_1_838_fbg26vlr_.arc, Sequence: 838","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_12/o1_mf_1_837_fbfmot25_.arc, Sequence: 837","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_12/o1_mf_1_836_fbfmljml_.arc, Sequence: 836","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Redo log: /u02/orafra/ERPLND3_3101V/archivelog/2018_03_12/o1_mf_1_835_fbffo5f2_.arc, Sequence: 835","source","",""
"3/13/2018 2:10:54 PM","ERROR","GLKAS4259V","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 843.","source","",""
"3/13/2018 2:10:54 PM","TRACE","GLKAS4259V","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
"3/13/2018 2:10:54 PM","ERROR","GLKAS4259V","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""

No RepliesBe the first to reply

Resources