Streams replication of batch processing
edited Nov 14, 2012 4:26AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Oracle 11gR2 OEL 5 64bit
We seem to be encountering many errors with our apply process during the execution of batch processing. We see many ORA-26787 and ORA-26787 errors in the error queue. These are occurring even though we have custom DML/Error handlers defined.
I know that Oracle documentation recommends to turn "off" replication (or the capture process) during batch processing and then run it separately on the replicated database, but what if we cannot do that? Let's say time is an issue. What are our other options?
Thank you.
We seem to be encountering many errors with our apply process during the execution of batch processing. We see many ORA-26787 and ORA-26787 errors in the error queue. These are occurring even though we have custom DML/Error handlers defined.
I know that Oracle documentation recommends to turn "off" replication (or the capture process) during batch processing and then run it separately on the replicated database, but what if we cannot do that? Let's say time is an issue. What are our other options?
Thank you.
0